Skip to main content
Date and time

Get Date Information

Get Date Information

Gets a complete set of information about a date, including day, month, year, name of the day of the week, limits of the week and of the month, and the first and last working days of the month. Ideal for assembling reports, automating monthly routines or applying calendar-based rules without having to calculate each value manually.


Options

Use a date relative to the robot's execution?

Defines whether the date used will be the current date at the moment of the execution. Select Yes to use the current date automatically, or No to provide a specific date.

Input format date

Select the format of the date provided. This field is only shown when Use a relative date is set to No and the date to be formatted is of the free text type.

Date to be formatted

Enter the date the information will be extracted from. This field is only shown when Use a relative date is set to No.

Date settings

Select a Date and time settings action so that holidays and non-working days are taken into account when the working days of the month are calculated. This field is optional.

Output language

Choose the language of the output date — for example Brazil Portuguese, producing an output such as 17 de abril de 2026.

Returns

Custom code

js
actions["action-id"].monthName // name of the month in full (Text)
actions["action-id"].month // number of the month (Number)
actions["action-id"].year // year (Number)
actions["action-id"].day // day of the month (Number)
actions["action-id"].dayName // name of the day of the week (Text)
actions["action-id"].firstDateOfTheWeek // first day of the current week (Text)
actions["action-id"].lastDateOfTheWeek // last day of the current week (Text)
actions["action-id"].firstDateOfTheMonth // first day of the month (Text)
actions["action-id"].lastDateOfTheMonth // last day of the month (Text)
actions["action-id"].firstWorkingDayOfTheMonth // first working day of the month (Number)
actions["action-id"].lastWorkingDayOfTheMonth // last working day of the month (Number)

Field selection

  • monthName — name of the month in full (Text)
  • month — number of the month (Number)
  • year — year (Number)
  • day — day of the month (Number)
  • dayName — name of the day of the week (Text)
  • firstDateOfTheWeek — first day of the current week (Text)
  • lastDateOfTheWeek — last day of the current week (Text)
  • firstDateOfTheMonth — first day of the month (Text)
  • lastDateOfTheMonth — last day of the month (Text)
  • firstWorkingDayOfTheMonth — number of the first working day of the month (Number)
  • lastWorkingDayOfTheMonth — number of the last working day of the month (Number)

Rules and Conditions

  • When Use a relative date is No, the Input format date and Date fields are required.
  • The Date settings field is optional — without it, the working-day fields are calculated without taking holidays into account.
  • The working-day fields depend on the holidays and days of the week configured in the action referenced.