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).
Solved! Go to Solution.
Hi @ysong943
You'll need to parse the data before formatting it:
DateTimeFormat(DateTimeParse([_CurrentField_],'%Y_%m'),"%b-%Y")
@ysong943 convert the given column heading into date type using the DateTimeParse function then apply the DateTimeFormat
DateTimeFormat(DateTimeParse([Field],’%Y_%m’),’%b-%y’)
@Luke_C Thank you so much!
@binuacsThank you, I appreciate it!!