Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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]