Change date format

[Venkateshp]

Hi team

how can i convert the date format(dd-mm-yyyy) to 

Required format(dd-Mon-yyyy) for multiple columns 

Example i have 01-01-2023 and i want is 01-JAN-2023

[NMangera · Accepted solution]

Spoiler

this should do the trick

[martinding · Accepted solution]

Hi @Venkateshp,

Let's say your date field is called [Date].

So in the formula tool, you will write:

DateTimeFormat([Date], "%d-%b-%Y")  and your data type should be set to a string type (e.g. String).

[binuacs · Accepted solution]

@Venkateshp One way of doing this

DateTimeFormat(DateTimeParse([Date],'%d-%m-%Y'),'%d-%b-%Y')