We used to do stuff like below, using EDIT to format date output:

TABLE FILE CAR
PRINT CAR
	COMPUTE I/I8 = 20121230;
	COMPUTE A/A7 = EDIT(I, '9999/99');

BY COUNTRY
END

Prior to WF77 this would return values in A as '2012/12'.

However, with WF77 these values are returned as '2012///'!

Is that intentional? If so, why is that?

This message has been edited. Last edited by: Wep5622,

I get "2012/12" in v7.7.03.

quote:

COMPUTE A/A7 = EDIT(I, '9999/99');

Well, I am on 7.7.03 and get the same result as Wep - had to do this to get it right:
COMPUTE I/I8 = 20121230;
-*** this worked
COMPUTE AP/A7 = EDIT(I, '9999')|'/'|EDIT(I,'$$$$99');

Same here on my 7.7.03.
Try the following:

  
TABLE FILE CAR
PRINT CAR
	COMPUTE I/I8 = 20121211;
	COMPUTE B/A7 = EDIT(I, '9999/99');
	COMPUTE A/A7 = EDIT(EDIT(I, '999999'),'9999/99');
BY COUNTRY
END

I tried in 7.1.6 (Unix), 7.6.6 (Unix), 7.6.11 (Unix) and 7.7.03 (Win) and all worked.

We're on 7.7.03, HotFix 6 (might as well be specific).

It worked.

Vivian, that is how I already worked around the issue to fix the problem for our customer. I was just wondering whether what I saw was expected behaviour. Apparently it's not.

nd, our WF client is on 7703 Hotfix 6 as well. Our server is 7704 though, might that be the difference?

Another possibility, our WF client & server are on a 64-bit OS. Perhaps there's a bug that shows up there that doesn't show on 32-bit systems?

This message has been edited. Last edited by: Wep5622,

WORKS at customer site 7.7.02

you're editing an Integer with a map that works on an Alpha
if you just fix that /I8 concept, you should be fine.

quote:

nd, our WF client is on 7703 Hotfix 6 as well. Our server is 7704 though, might that be the difference?

It might be the server versions. It might also be a big load of frustrating.

If you haven't opened a support ticket, it might be worth it, to save someone else the bug down the line.

Well, even though the code worked for me, susannah is right - the code is doing two things at once - converting from integer to alpha and also embedding a slash - this should be done in two steps.

This message has been edited. Last edited by: Francis Mariani,

I do agree as well. If this is a loophole, then it may well disappear during code tightening in the future.

Oh dear, we use EDIT to do precisely this all the time! Apparently, an IBI consultant taught us to do conversions from integer to alpha just like this.

If that behaviour has changed, we're looking at a fairly serious backwards compatibility issue. I'll open a case.

Wep, your code is perfectly fine and should produce 2012/12. You are doing a numeric edit with mask and this has been supported forever. Opening a case with CSS should solve this problem for you, which may be some environmental issue- it may be windows specific.

Server 7704M Gen 773 (such a confusing gen-number!) fixed the issue.

Well, I guess some of us were being too strict about the code.