Grow has logic in place to help convert dates in the most common formats into a standard
YYYY-MM-DD HH:MM:SS format to make it easier to work with your data. However, sometimes the data comes in formatted in a way that Grow won't recognize, which can then make it hard to use with other date-based transforms or chart formatting options. (For example, when you want to group by month or use the dates as the x-axis.)
For the date formats that Grow can't recognize, we created the Format As Dates transform to let you tell Grow what format your dates are in, and Grow will take care of the rest.
Selecting the Date Format
- To use this transform, you will first select the date column you want to reformat.
- Then in the Incoming date format box select each part of the current date format in that column. This will tell Grow where to look for each date part when it updates that column.
- Next select the format of each date part. For example, if your date is "Jan 02", you will select "Month: 'Jun'" and "Day: '01-31'".
- Click Run and your column will be reformatted into the standard format.
Here are the options for selecting the date parts in the transform:
|Date Part||Formatting Options|
|Day||Day of Month|
Day of Week
Day of Year
|Wildcard||Use this is a placeholder for anything not included in the other options|
|Custom Text||If you have a specific string that is included in all dates, you can enter it here|