Focal Point
Date issue in webfocus 532

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9081008331

October 19, 2004, 06:49 PM
<kj>
Date issue in webfocus 532
Has any one experienced with this isssue?

-SET &DT1= '20041201';
-SET &DTYYMD=DATECVT(&DT1 ,'I8YYMD','YYMD');
-SET &DATEMDYY=DATECVT(&DT1 ,'I8YYMD','YYMD');

The variable &DTYYMD displays 37956, where as &DATEMDYY displays current date in yymd format.
This is happening after upgrading to webfocus 532 on win2k. Both the variables displays 37956 in 521 & 526.
Any Idea why is it happening?

Thanks,
kj
October 20, 2004, 06:36 PM
<RJones>
Try removing the 'I8' on the input format for the &DTYYMD field:

-SET &DTYYMD=DATECVT(&DT1 ,'YYMD','YYMD');

On the second one &DATE is a reserved word and by adding MDYY or YYMD to it, it changes the format, so the DATECVT is being ignored. You can see this by trying:
-TYPE &DATE
-TYPE &DATEMDYY
October 20, 2004, 09:19 PM
susannah
KJ, since your're using the datecvt function, i'm assuming that you in fact WANT a smart date as a result.
And that number 37956 is exactly correct, its the smartdate being held in variable &DTYYMD.
Smartdates are integers representing the number of dates elapsed since the beginning of the last century ; theres a difference between the way FOcus calculates it and Excel calculates it, but you can get the idea by going to Excel and entering 12/1/04 in a date formated cell a1,
and then in another cell enter =value(a1) and you'll see 38322. This is how both applications handle date arithmetic.
So if you WANT a smart date in an &var, you've got it.
If you DON"T want a smart date in an &var, then don't use the DATECVT function.