Stardardize the date format

[Black_Hole]

Hello all,

I have a column for the field date.

In this column, there is two types of format YYYY/MM/DD and DD/MM/YYYY.

I would like to use a unique format which will be YYYY/MM/DD.

I try to standardize using the expression below:

                           DATE#(LastDate,'YYYY/MM/DD')

But, after to run my script, there is no modification, I still have the both formats.

Please could you help me to resolve this problem.

Thank you in advance for your help.

[dplr-rn · Accepted solution]

date# function is to convert a text to date/numeric. not to format it
since you say it is within same column try with this DATE(LastDate,'YYYY/MM/DD') and check results

if it doesnt we may need to be more creative. check and let me know

[Black_Hole]

Hello @dplr-rn ,

The expression above works perfectly. 

Thanks a lot for your help 👍