Change the Date format

[SurbhiMittal]

Hi Team,

I have column named date in the following format i.e. 10-01-2023 (dd-mm-yyyy) as an input.

I want to create new column as "Period" in the output as Jan-23.(mmm-yy).

Please let me know the right formula to use for the same.

[ShankerV]

Hi @SurbhiMittal 

Please use

datetimeformat(datetimeparse([Field1],"%d-%m-%y"),"%b-%y")

Many thanks

Shanker V