Convert dd.mm.yyyy to mmm

[RDF25087]

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 solution]

Hi @RDF25087 

Please use the below in Formula tool.

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

Many thanks

Shanker V

[RDF25087]

@ShankerV- that's perfect. Thanks for the quick response. I'll accept that as the solution.

I've used the month as the column headers in a cross tab. However, it's put the table into alphabetical order, i.e. Apr, Aug, Feb etc... Would you know how to change the cross tab view to Jan, Feb, Mar etc...

Thanks

RDF