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.
    • 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. 

Next lesson
Freight & Logistics
Retail & Ecomm
Automatically manage your CRM
Automatically update store inventory
Better, faster, more powerful reports
Custom metrics, anywhere
Ecommerce Marketing Flows
Ecommerce Operations Flows
Generate rich customer insights
Go beyond the limitations of spreadsheets
Intelligent search and email marketing
Manage unique products
Powerful, custom reporting
Quickly respond to low inventory
RevOps Use Cases
Set up triggered alerts (even complicated ones)
Support your Sales team
Use APIs without any code