Date transforming

[Aleksandar1]

How i can transform date yyyy-mm-dd to yyyy/mm/dd?

Thanks in advance

[ShankerV · Accepted solution]

Hi @Aleksandar1 

Please use below.

Datetimeformat([Columnname],"%Y/%m/%d")

Make sure you store the above in Vstring datatype.

Many thanks

Shanker V

[caltang]

If your date is stored as a V_WString, then you can try:

DateTimeFormat(DateTimeParse([YourDateHere],"%Y-%m-%d"),"%Y/%m/%d")

If your date is already stored as a date type, then you can ignore the DateTimeFormat part and go directly to DateTimeParse section.

Hope this helps!

-Cal