Hi all,
It is possible to use the virtual Date table from code?
Using it as a data item in a report or page works, but when I try to access and loop it in code it doesn't.
Date.SETRANGE("Period Type",Date."Period Type"::Month);
Date.SETRANGE("Period Start",StartDate);
Date.SETRANGE("Period End",EndDate);
IF Date.FINDSET THEN
REPEAT
//blah blah
UNTIL Date.NEXT =0;
This returns 0 Date results.
0
Answers
Of course the range should be Date.SETRANGE("Period Start",StartDate,EndDate);