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
Solved! Go to Solution.
Hi @RDF25087
Please use the below in Formula tool.
datetimeformat(datetimeparse([Invoice Date],"%d.%m.%y"),"%b")
Many thanks
Shanker V
@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