change date format

[mewmew18102]

Hey community:)

I am wanting to change the 'TransactionDate' format from 2022-07-15 to 15-JUL-22. I do not want to add a new column, I want to change it within the same column without needing to add a new one. 

"ssss" Screenshot shows what it looks like now

"ss" screenshot shows how I want it too look

[ChrisTX]

You'll need to change the field's data type to a string.

Try the Multi-Field Formula tool with this expression:  DateTimeFormat([My Date],"%d-%b-%y")

 

Chris

[mewmew18102]

Is there a way where I don't have to add a new column and just change it in the original column?

[jdminton]

@mewmew18102 yes, use the multifield formula tool. That has a checkbox to keep the results in the same column AND allow you to change the data type. To present the date in the format you would like, you would need a different formula and the output would need to be some form of string unless you add some reporting tools to change the output or use formatting in Excel after the output.

 

[Raj]

@mewmew18102 
use formula tool 
"DateTimeFormat(DateTimeParse([Field], "%Y-%m-%d"), "%d-%b-%y")" this will work for your case.

[ChrisTX]

A formula tool will not work in this case because of this requirement:

I want to change it within the same column without needing to add a new one