How to make date transfer into special expression?

[phoebe_90]

How to transform m/d/yyyy into m'yy automatically?

For example 

transform 8/28/2023 into Aug'23

[ShankerV]

Hi @phoebe_90 

Please use the below formula tool.

DateTimeFormat(DateTimeParse([Field1],"%m/%d/%y"),"%b'%y")

Many thanks

Shanker V