Is there a way to recognize this format as a date: 4 Jan 2022?

I’m pulling in date data from one source that is formatted as 4 Jan 2022 (January 4th, 2022) and I’d like to transform it into 01/04/2022. Is there an easy way to do this?

I’m thinking about creating 12 conditionals that transform each month into a number, but I’d like to avoid doing this if there’s an easier way out there.

Hi Carlos! Yes you’ll be able to format your date by using the Format date step and setting the Starting Format to “D MMM YYYY”, and the New Format to “MM/DD/YYYY”.

Linking you to our Format date page in case you come across other formats.

Let us know if you have other questions!

  • Ayana

Thank you so much! This capability was not immediately clear in the interface, but now that I know it works I’m even more amazed by Parabola. I literally used 14 steps to achieve this same result that I now know can be achieved with a single step.

1 Like