Regarding Date function

[#1]

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]

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 · Accepted solution]

If neither works, then try this

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

[#4]

Thank you Sunny,I appreciate your help!

Kiruthiga