topic Re: Date Format in Script in QlikView

Date Format in Script

Anonymous — Thu, 19 May 2016 08:45:58 GMT

Hello,

I would like to create a variable on my script with a specific Date Format. I tried this:

But when i look into the data structure i see this:

The Format doesn't work :/.

I need this because i do a check between two variables:

AsOf_E = Last_Update_Projection

And AsOf_E is configured like this:

Thanks you in advance for your help,

Sébastien.

PrashantSangle — Thu, 19 May 2016 08:48:19 GMT

Hi,

Use date() instead of date#()

Regards

MK_QSL — Thu, 19 May 2016 08:51:18 GMT

Date(Date#(Max(AsOf_E,'DD/MM/YYYY')) as

Chanty4u — Thu, 19 May 2016 08:55:22 GMT

try

Load,

Date(Date#(Max(Asof_E,'Dateformat')) as new

Kushal_Chawda — Thu, 19 May 2016 09:00:23 GMT

just Date function will work

MaxDate:

LOAD

Date(Max(AsOf_E) ,'DD/MM/YYY') as [LastAsOf]

...

LET Last_Update_Projection = peek('LastAsOf',0,'MaxDate');

Thu, 19 May 2016 09:01:42 GMT

Hi ,

Load Date(Date#(Max(Asof_E,'DD/MM/YYYY')) as [LastAsOf]

sunny_talwar — Thu, 19 May 2016 10:04:27 GMT

I think Manish you forgot to close Max() function

sunny_talwar — Thu, 19 May 2016 10:05:30 GMT

Not sure if Date#() function is still required to interpret the date.

Date(Date#(Max(AsOf_E),'DD/MM/YYYY'), 'DD/MM/YYYY') as [LastAsOf]