Date: Fri, 29 Mar 2024 11:38:34 +0100 (CET) Message-ID: <432276281.548.1711708714344@apps-confluence-5.apps-confluence.apps.svc.cluster.local> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_547_229409969.1711708714344" ------=_Part_547_229409969.1711708714344 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
addTime()
for Schedules Definition Grammar now supports negative offsets:Function | Returned value |
---|---|
addTime(number base_ins= tant, number offset, string schedule_name= , timeZone time_zone) : number | Returns the time instant resulting of adding Example: addTime(2017/12/01 01:00, 8 * {HOUR} + 31 * {MINUTE=
}, "my_schedule", LOCAL) returns 2017/12/04 10:01=
strong>.Example: addTime(2017/12/04 14:00, 2 * {HOUR} + 30 * {MINUTE=
}, "my_schedule", LOCAL) returns 2017/12/04 17:00=
strong>.Since version 2.= 2.41 negative offset values are supported: Example: addTime(2017/04/24 09:00, - 2 * {HOUR}, "my_schedul=
e", LOCAL) returns 2017/04/21 14:00.Example: addTime(2017/04/20 20:30, - 5 * {HOUR}, "my_schedul=
e", LOCAL) returns 2017/04/20 13:00. |
In the examples above we have used schedule "my_schedule"
, =
whose definition in Schedules Definition Grammar is:
Note that 2017/12/01
is Friday, and 2017/12/04
i=
s Monday.
$formatedValue
in column view when returned va=
lue was null
.toNumber()
and st=
ringToDate()
threw an exception when input parameter was a =
null
instead of a string.