Convert string to date

[hemant86]

Hi All,

I have a date time column in the below format. Need to convert as in the output mentioned below. Appreciate any quick fix 

Date and Time of Transaction

May 1, 2023 11:54pm

Required Output-

Date and Time of Transaction

1-May-2023

[Raj · Accepted solution]

use 
"DateTimeFormat((DateTimeParse([Field1],"%B %d, %Y")),"%d-%b-%Y")"

[hemant86]

Thanks @Raj for the quick help. Much appreciated