topic Re: Date Format in QlikView

Date Format

tmumaw — Wed, 03 Aug 2016 14:44:29 GMT

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

Re: Date Format

Mark_Little — Wed, 03 Aug 2016 14:46:20 GMT

Hi Thom,

Where are you setting vToday?

Maybe try

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

Mark

Re: Date Format

sunny_talwar — Wed, 03 Aug 2016 14:47:00 GMT

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;

Re: Date Format

tmumaw — Wed, 03 Aug 2016 14:50:38 GMT

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