Converting V_wstring to new date format

[xiaofanchen]

Hello all,

I was wondering how do I convert this field to read  'yyyy-mm-dd', the time part need to be omitted as well. For example, the first cell would be 2023-01-02

Thank you in advance!

[Felipe_Ribeir0 · Accepted solution]

Hi @xiaofanchen 

You can use this formula

DATETIMEPARSE([Transaction Date], '%m/%d/%Y')

[xiaofanchen]

You are awesome!! Thank you @Felipe_Ribeir0