Parabola’s Format dates step converts date and time values from any format into a standardized format that fits your needs.

Building challenge

• Add a card titled “Format date values” directly to the right of your “Pull sales data” card.
• To the card, add a Format dates step and reformat the Order Date column to the YYYY-MM-DD format.
• Using another Format dates step (after the one you just added), create a new column called Month which includes values like January 2024 and February 2024 based on the Order Date.
  • Pro tip: Leverage the Table at the bottom of the support docs. 

To check your work, take a look at this quick video.

Using the step

1. Drag an Edit columns step onto the canvas.
2. Select columns to format. Start by choosing the columns that contain date information. 
3. Specify starting and ending date formats. Input the current format of the date values, then define the desired output format. 
   • Ex) 2024-05-04 = YYYY-MM-DD 

Pro tip

• Use the formatting guide at the bottom of our support docs to help specify the starting and ending formats.

Visit our support docs to learn more about the step.