change date format

Question

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

Screenshot 2024-04-01 213052.png

ss.png

ssss.png

ChrisTX · Answer

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

Raj · Answer

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

jdminton · Answer

@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.