Converting format of column header date (2023_03) to Mar-23

[ysong943]

Hey all, I have a bunch of column headers with dates in the format 2023_03, 2023_04, etc, but I want them to be Mar-23, Apr-23 etc.

I tried using the Dynamic Rename Tool and putting in the expression box: DateTimeFormat([_CurrentField_],"%B-%Y") but it does nothing (no changes). 

[Luke_C · Accepted solution]

Hi @ysong943 

You'll need to parse the data before formatting it:

DateTimeFormat(DateTimeParse([_CurrentField_],'%Y_%m'),"%b-%Y")

[binuacs]

@ysong943 convert the given column heading into date type using the DateTimeParse function then apply the DateTimeFormat 

DateTimeFormat(DateTimeParse([Field],’%Y_%m’),’%b-%y’)

[ysong943]

@Luke_C Thank you so much!

[ysong943]

@binuacsThank you, I appreciate it!!