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: 
Not applicable

Regarding Date function

Hello Friends,

I appreciate your help.

I have a date field with values like 2009-02-25,39459,39460 and so on.

I am trying to do the following scripting change for the field but it is not displaying any result.

DATE(date#(NUM([ Date_Field]),'YYYY-MM-DD'),'DD/MM/YYYY') as date_field.

Thank you again!

Kiruthiga

1 Solution

Accepted Solutions
sunny_talwar

If neither works, then try this

Date(Alt(Num([ Date_Field]), Num(Date#([ Date_Field]), 'YYYY-MM-DD'))), 'DD/MM/YYYY') as date_field

View solution in original post

3 Replies
sunny_talwar

How about this

Date([ Date_Field], 'DD/MM/YYYY') as date_field

or

Date(Date#([ Date_Field]), 'YYYY-MM-DD'), 'DD/MM/YYYY') as date_field

sunny_talwar

If neither works, then try this

Date(Alt(Num([ Date_Field]), Num(Date#([ Date_Field]), 'YYYY-MM-DD'))), 'DD/MM/YYYY') as date_field

View solution in original post

Not applicable
Author

Thank you Sunny,I appreciate your help!

Kiruthiga