This simple step allows you to convert the date units of values in Date columns.

  1. Select one or many date columns

  2. Select the desired date unit.

Notes:

  • There is no exact conversion from Week into Month, Year or Quarter since weeks do not necessarily start at the beginning of a Month, a Year, or a Quarter.

  • If you try converting units from Month, Year, or Quarter into a more granular unit – for example from Month to Day – Workbench will pick the first possible date values.

Did this answer your question?