Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If neither works, then try this
Date(Alt(Num([ Date_Field]), Num(Date#([ Date_Field]), 'YYYY-MM-DD'))), 'DD/MM/YYYY') as date_field
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
If neither works, then try this
Date(Alt(Num([ Date_Field]), Num(Date#([ Date_Field]), 'YYYY-MM-DD'))), 'DD/MM/YYYY') as date_field
Thank you Sunny,I appreciate your help!
Kiruthiga