The Explode Date function automatically splits date-time fields in your sheet to new columns. To use Explode Date, navigate to the Functions (Fx) menu and select Explode Date, then select any valid date-time column.
For example, exploding a UTC date-time stamp will result in these new columns:
- Year
- Month
- Day
- Day of Week
- Hour
- Minute
- Seconds
- Time Zone