| DateTime Functions |
[This is preliminary documentation and is subject to change.]
TOPICA Basic Date/Time FunctionsName | Description |
|---|---|
Now | Get current date and time |
Today | Get current date |
Year | Get year from DateTime value. |
Month | Get month from DateTime value. |
Day | Get day from DateTime value. |
Date | Get date part from DateTime value, or construct a DateTime value from year, month, day (optionally hour and minute) values. |
DateEndIfNoTime | Get last minute on the day (1 minut before midnight), if the input DateTime value does already have a time part. |
InDateInterval | Check if supplied DateTime value is with a specified date interval. |
InDateTimeInterval | Check if supplied DateTime value is with a specified date/time interval. |
DateDiff_Month | Get # months between to DateTime values |
DateDiff_Day | Get # days between to DateTime values |
DateDiff_Hour | Get # hours between to DateTime values |
DateDiff_Minute | Get # minutes between to DateTime values |
AddMonths | Add months to DateTime value |
AddHours | Add hours to DateTime value |
AddMinutes | Add minutes to DateTime value |