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
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.