Date Format

[bh1789]

I was using the following formula:

DateTimeFormat(DateTimeParse([ReviewedDate],"%Y-%m-%d"), "%b %y")

but the source data changed from "%Y-%m-%d" to 2024-Apr-16

can someone help me adjust my formula so that 2024-Apr-16 gives an output of "%b %y"

Thank you,

[Bren_Spill2 · Accepted solution]

@bh1789 - DateTimeFormat(DateTimeParse([Review Date Updated],"%Y-%b-%d"), "%b %y")