Converting YYYY-MON to YYYYDD

[Jake5]

Hello - I have an input file that displays date as YYYY-MON (e.g. 2022-Jan) and I need to convert it to YYYYMM (202201).  The DateTime tool doesn't seem to work for this, but I presume a formula tool can do this by way of a swap (e.g. replace '-Jan' with '01').  Welcome any specific suggestions, though.  Thanks!

[binuacs · Accepted solution]

@Jake5 One way of doing this with the DateTime functions

DateTime Functions | Alteryx Help

[christine_assaad]

Hi @Jake5 

Here is a way of doing it. Cheers!

[Jake5]

Thank you both!  That worked.