Convert dd.mm.yyyy to mmm

Question

Hi all -

I have a data set with a field called Invoice Date. The dates in this field are in the format dd.mm.yyyy. They are also in a V_WString format. I would like to extract the month from these dates in the mmm format. e.g. If the Invoice Date was 22.09.2023 I'd like a new column with the output Sep.

Thanks for any help.

RDF

ShankerV · Accepted Answer

Hi @RDF25087

Please use the below in Formula tool.

datetimeformat(datetimeparse([Invoice Date],"%d.%m.%y"),"%b")

Many thanks

Shanker V