Date Functions
Functions for working with dates and times.
Now
Returns the current date and time.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 0 |
| Returns | date |
Description: Returns the current timestamp in UTC format.
Example:
Now() → 2026-01-15T14:30:00Z
Day
Extracts the day component from a date.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 1 |
| Returns | integer |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | datetime | date | The date to extract from |
Example:
Day(2026-01-15) → 15
Day(OrderDate) → day of month (1-31)
Month
Extracts the month component from a date.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 1 |
| Returns | integer |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Date | date | The date to extract from |
Example:
Month(2026-01-15) → 1
Month(OrderDate) → month number (1-12)
Year
Extracts the year component from a date.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 1 |
| Returns | integer |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Date | date | The date to extract from |
Example:
Year(2026-01-15) → 2026
Year(BirthDate) → birth year
Day Of Week
Returns the day of the week (0-6) from a date.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 1 |
| Returns | integer |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | datetime | date | The date to extract from |
Description: Returns 0 for Sunday, 1 for Monday, ..., 6 for Saturday.
Example:
Day Of Week(2026-01-15) → 4 (Thursday)
Add Days
Adds days to a date.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 2 |
| Returns | date |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Base Date | date | Starting date |
| 1 | Days to add | integer | Number of days (can be negative) |
Example:
Add Days(2026-01-15, 30) → 2026-02-14
Add Days(OrderDate, 5) → expected shipping date
Add Days(Now(), -7) → one week ago
Add Hours
Adds hours to a timestamp.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 2 |
| Returns | date |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Base Date | date | Starting timestamp |
| 1 | Hours to add | integer | Number of hours (can be negative) |
Example:
Add Hours(Now(), 24) → same time tomorrow
Add Hours(StartTime, 8) → end of shift
Add Minutes
Adds minutes to a timestamp.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 2 |
| Returns | date |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Base Date | date | Starting timestamp |
| 1 | Minutes to add | integer | Number of minutes (can be negative) |
Example:
Add Minutes(Now(), 30) → 30 minutes from now
Add Minutes(MeetingStart, 60) → meeting end time
Add Seconds
Adds seconds to a timestamp.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 2 |
| Returns | date |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Base Date | date | Starting timestamp |
| 1 | Seconds to add | integer | Number of seconds (can be negative) |
Add Month
Adds months to a date.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 2 |
| Returns | date |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Base Date | date | Starting date |
| 1 | Months to add | integer | Number of months (can be negative) |
Example:
Add Month(2026-01-15, 3) → 2026-04-15
Add Month(ContractStart, 12) → contract end date (1 year)
Add Years
Adds years to a date.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 2 |
| Returns | date |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Base Date | date | Starting date |
| 1 | Years to add | integer | Number of years (can be negative) |
Example:
Add Years(2026-01-15, 5) → 2031-01-15
Add Years(BirthDate, 18) → 18th birthday
Days Diff
Calculates the difference in days between two dates.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 2 |
| Returns | float |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Start Date | date | First date |
| 1 | Target Date | date | Second date |
Description: Returns Target Date minus Start Date in days. Result can be fractional and negative.
Example:
Days Diff(2026-01-01, 2026-01-15) → 14
Days Diff(OrderDate, Now()) → days since order
Days Diff(Now(), DueDate) → days until due
Hours Diff
Calculates the difference in hours between two timestamps.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 2 |
| Returns | float |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Start Date | date | First timestamp |
| 1 | Target Date | date | Second timestamp |
Minutes Diff
Calculates the difference in minutes between two timestamps.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 2 |
| Returns | float |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Start Date | date | First timestamp |
| 1 | Target Date | date | Second timestamp |
Months Diff
Calculates the difference in months between two dates.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 2 |
| Returns | integer |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Start Date | date | First date |
| 1 | Target Date | date | Second date |
Years Diff
Calculates the difference in years between two dates.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 2 |
| Returns | float |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Start Date | date | First date |
| 1 | Target Date | date | Second date |
Example:
Years Diff(BirthDate, Now()) → age in years
Start Of Day
Returns midnight (00:00:00) of the given date.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 1 |
| Returns | date |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Base DateTime | date | The date/time |
Example:
Start Of Day(2026-01-15T14:30:00) → 2026-01-15T00:00:00
Start Of Hour
Returns the beginning of the hour (XX:00:00).
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 1 |
| Returns | date |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Base DateTime | date | The date/time |
Example:
Start Of Hour(2026-01-15T14:45:30) → 2026-01-15T14:00:00
Start Of Month
Returns the first day of the month.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 1 |
| Returns | date |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Base DateTime | date | The date/time |
Example:
Start Of Month(2026-01-15) → 2026-01-01T00:00:00
Ticks
Returns the ticks value from a timestamp.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 1 |
| Returns | integer |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Date | date | The timestamp |
Description: Returns the number of 100-nanosecond intervals since January 1, 0001. Useful for precise time comparisons.
Parse DateTime
Converts a string to a date/time value.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 1 |
| Returns | date |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | DateTime String | string | Text to parse |
| 1 | Format (optional) | string | Expected format pattern |
Example:
Parse DateTime("2026-01-15") → 2026-01-15T00:00:00
Parse DateTime("01/15/2026", "MM/dd/yyyy") → 2026-01-15T00:00:00
Convert From UTC
Converts a UTC timestamp to a target time zone.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 2 |
| Returns | date |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Base Date | date | UTC timestamp |
| 1 | Time zone | optionSet | Target time zone |
Description: Converts from Universal Time Coordinated (UTC) to the specified time zone. Time zone options include all standard time zones.
Convert To UTC
Converts a timestamp from a source time zone to UTC.
| Property | Value |
|---|---|
| Category | Date Functions |
| Min Arguments | 2 |
| Returns | date |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Base Date | date | Local timestamp |
| 1 | Time zone | optionSet | Source time zone |