Date Format

[tmumaw]

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

[Mark_Little]

Hi Thom,

Where are you setting vToday?

Maybe try

LET vFormatToday = date(Today(), 'YYYY-MM-DD')

Mark

[sunny_talwar · Accepted solution]

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;

[tmumaw]

Thanks Sunny T.....That worked perfect.