Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am having an issue with trying to put the current date onto a QVD. I am getting 1905-06-27 in RunDate. Here is what I am doing:
LET vFormatToday = date(vToday, 'YYYY-MM-DD')
Employee_Status:
LOAD DISTINCT
*,
[Employee Number] & '-' & [Week Ending] AS LinkKey,
Date($(vFormatToday), 'YYYY-MM-DD') as RunDate
RESIDENT PA0000;
Thanks
Try this:
LET vFormatToday = Num(vToday);
Employee_Status:
LOAD DISTINCT
*,
[Employee Number] & '-' & [Week Ending] AS LinkKey,
Date($(vFormatToday), 'YYYY-MM-DD') as RunDate
RESIDENT PA0000;
Hi Thom,
Where are you setting vToday?
Maybe try
LET vFormatToday = date(Today(), 'YYYY-MM-DD')
Mark
Try this:
LET vFormatToday = Num(vToday);
Employee_Status:
LOAD DISTINCT
*,
[Employee Number] & '-' & [Week Ending] AS LinkKey,
Date($(vFormatToday), 'YYYY-MM-DD') as RunDate
RESIDENT PA0000;
Thanks Sunny T.....That worked perfect.