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