SUBTRACT_TIME()

Prev Next

Description

Subtracts a given duration unit from a given time. If a tz identifier is provided, uses that time zone instead of the local time zone.

Available In

  • Apps
  • Automations

Syntax

SUBTRACT_TIME(date: Datetime or Date, amount: Integer, unit: Text, timezone?: Text)

Example

SUBTRACT_TIME(02/03/2019 12:30, 1, 'months', 'Asia/Baghdad') = 01/03/2019 12:30