ToDate and ToTimeOfDay.
Now
Returns the current moment for the active formula evaluation.
- Syntax:
Now() - Requires: the evaluation clock supplied by Dsync.
- Returns: Timestamp.
- Best for: age checks, audit values, and comparisons with a deadline.
Now() call in one evaluation observes the same moment, which keeps comparisons consistent.
Timestamp
Constructs a timestamp directly in UTC.
- Syntax:
Timestamp(year, month, day, hour, minute, second) - Requires: six numeric components with a valid calendar date. Time components are normalised within a 24-hour day, and seconds may include a millisecond fraction.
- Returns: Timestamp.
- Best for: fixed UTC moments supplied by an integration or specification.
Use
ToTimestamp(date, time, timeZone) when your inputs describe local time in a named timezone.