Focal Point
Date issue in webfocus 532

This topic can be found at:

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

-SET &DT1= '20041201';

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?

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


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:
October 20, 2004, 09:19 PM
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.