Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
cocalero
Creator
Creator

Date Format in Script

Hello,

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

Capture.PNG

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

Capture.PNG

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:

Capture.PNG

Thanks you in advance for your help,

Sébastien.

1 Solution

Accepted Solutions
Kush
MVP
MVP

just Date function will work

MaxDate:

LOAD

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

...



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

View solution in original post

7 Replies
PrashantSangle

Hi,

Use date() instead of date#()

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
MK_QSL
MVP
MVP

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

Chanty4u
Champion III
Champion III

try

Load,

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

Kush
MVP
MVP

just Date function will work

MaxDate:

LOAD

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

...



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

View solution in original post

Not applicable

Hi ,

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

sunny_talwar

I think Manish you forgot to close Max() function

sunny_talwar

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]