topic Regarding Date function in QlikView

Regarding Date function

Wed, 29 Mar 2017 18:27:21 GMT

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

sunny_talwar — Wed, 29 Mar 2017 18:29:11 GMT

How about this

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

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

sunny_talwar — Wed, 29 Mar 2017 18:30:21 GMT

If neither works, then try this

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

Wed, 29 Mar 2017 19:49:24 GMT

Thank you Sunny,I appreciate your help!

Kiruthiga