Extract date information

The Extract date information step allows to extract date information from a date column (e.g. the year or the month).

Step parameters

  • Date column column(string)*: specify the date column to extract information from (the column must be of date data type),

  • Date information to extract... array(string)*: the type of information to extract (e.g. year, month). You can select several information to extract at once.

Example

Input

Date - Extract date information

Configuration

{
  "column": "date_column",
  "date_info": ["year", "month", "days"],
}

Output

Date - Extract date information output

The following information can be extracted:

  • year': extract ‘year’ from date,

  • month: extract ‘month’ from date,

  • day: extract ‘day of month’ from date,

  • week: extract ‘week number’ (ranging from 0 to 53) from date,

  • quarter: extract ‘quarter number’ from date (1 for Jan-Feb-Mar)

  • day of week: extract ‘day of week’ (ranging from 1 for Sunday to 7 for Staurday) from date,

  • day of year: extract ‘day of year’ from date,

  • ISO year: extract ‘year number’ in ISO 8601 format (ranging from 1 to 53) from date.

  • ISO week: extract ‘week number’ in ISO 8601 format (ranging from 1 to 53) from date.

  • ISO day of week: extract ‘day of week’ in ISO 8601 format (ranging from 1 for Monday to 7 for Sunday) from date,

  • first day of year: calendar date corresponding to the first day (1st of January) of the year ,

  • first day of month: calendar date corresponding to the first day of the month,

  • first day of week: calendar date corresponding to the first day of the week,

  • first day of quarter: calendar date corresponding to the first day of the quarter,

  • first day of ISO week: calendar date corresponding to the first day of the week in ISO 8601 format,

  • previous day: calendar date one day before the target date,

  • first day of previous year: calendar date corresponding to the first day (1st of January) of the previous year,

  • first day of previous month: calendar date corresponding to the first day of the previous month,

  • first day of previous week: calendar date corresponding to the first day of the previous week,

  • first day of previous ISO week: calendar date corresponding to the first day of the previous ISO week,

  • first day of previous quarter: calendar date corresponding to the first day of the previous quarter,

  • previous year number: extract previous ‘year number’ from date,

  • previous month number: extract previous ‘month number’ from date,

  • previous week number: extract previous ‘week number’ from date,

  • previous quarter number: extract previous ‘quarter number’ from date,

  • previous ISO week number: extract previous ‘week number’ in ISO 8601 format (ranging from 1 for Monday to 7 for Sunday)from date,

  • hour: extract ‘hour’ from date,

  • minutes: extract ‘minutes’ from date,

  • seconds: extract ‘seconds’ from date,

  • milliseconds: extract ‘milliseconds’ from date,

Last updated

Was this helpful?