Skip to main content
Docs
Go to the Studio
Roberty Studio
RPADate 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, week and month boundaries, and the first and last working days of the month. Ideal for building 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: Traditional (31/12/2024), In full (31 de dezembro de 2024) or International (2024-12-31). This field is only shown when Use a date relative to the robot's execution? is set to No.

Date to be formatted​

Enter the date from which the information will be extracted. This field is only shown when Use a date relative to the robot's execution? is set to No.

Select the date settings​

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

Output language​

Choose the language of the output information — Brazil Portuguese or English. For example, with Brazil Portuguese the month name is returned as abril.

Returns​

Javascript code​

js
actions["action-id"].monthName                 // full name of the month (Text)
actions["action-id"].month                     // month number (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 date's week (Text)
actions["action-id"].lastDateOfTheWeek         // last day of the date's 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 — full name of the month (Text)
  • month — month number (Number)
  • year — year (Number)
  • day — day of the month (Number)
  • dayName — name of the day of the week (Text)
  • firstDateOfTheWeek — first day of the date's week (Text)
  • lastDateOfTheWeek — last day of the date's 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 date relative to the robot's execution? is No, the date provided must match the format selected in Input format date.
  • The Select the date settings field is optional — without it, firstWorkingDayOfTheMonth and lastWorkingDayOfTheMonth correspond to the first and last day of the month, without taking holidays into account.
  • The week and month dates (firstDateOfTheWeek, lastDateOfTheWeek, firstDateOfTheMonth, lastDateOfTheMonth) are returned in the Traditional format (31/12/2024).