Change date format

[SH_94]

Dear community,

I would like to ask how we can change the date format as below :

I have attached the file below for your reference.

Thank you.

[BRRLL99 · Accepted solution]

Hi

Use Formula Tool >> Add new Column >> DateTimeFormat([Date],"%b-%Y")

[BRRLL99]

Hi

IF you want to replace "-" with blank you can use this formula

If your query is resolved, Please Mark it as solved

[binuacs]

@SH_94 @BRRLL99 for the desired output (MMM YYYY)you can mention the same format inside the DateTimeFormat function. I men no need to use the replace function