Format dates
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.
To check your work, take a look at this quick video.
Using the step
- Drag a Format dates step onto the canvas.
- Select columns to format. Start by choosing the columns that contain date information.
- 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.