Skip to main content
Go to the Studio
Functions

Date and Time Manipulation

Date and Time Manipulation

Applies one or more operations of adding or subtracting time units to a base date, returning the resulting date. Ideal for calculating deadlines, due dates, accounting periods or any situation that requires navigating the calendar from a known date.


Options​

Date Input Format​

Select the format in which the input date is written. The format must match exactly the date provided.

Use a relative date?​

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

Inform the date​

Enter the base date to which the operations will be applied. This field is only shown when Use a relative date is set to No.

Available manipulation functions​

Add one or more operations to be applied to the date. Each operation contains:

  • Manipulation function — choose between Add to the date (move forward in time), Subtract from the date (move backward in time), Start the date at or End the date at
  • Amount — enter the numeric value of the operation
  • Unit of time — select the time unit: years, months, weeks, days, hours, minutes or seconds

The operations are executed in sequence, in the order in which they were added.

Returns​

Custom code​

js
actions["action-id"].value // resulting date after all the operations are applied (Text)

Field selection​

  • value — resulting date in the same format as the input, after the manipulations (Text)

Rules and Conditions​

  • The Date Input Format field is required.
  • When Use a relative date is No, the Date field is also required.
  • At least one operation must be added for the action to have any effect.
  • The operations are applied in cascade — the result of one is the base of the next.