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

Hi @xiaofanchen 

You can use this formula

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

DATE13.yxmd