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. In this case, Grow will cast that column as the text datatype 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 these date formats that Grow can't recognize (and are currently sitting as a text datatype), we created the Format as Date transform to let you tell Grow what format your dates are in. This way Grow will recognize that column as a date.
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|