Convert string to date

Question

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 TransactionMay 1, 2023 11:54pm

Required Output-

Date and Time of Transaction1-May-2023

Raj · Accepted Answer

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