DateTime
Actions for reading, converting, comparing and calculating with dates and times.
The DateTime folder holds the actions that work with dates and times.
PROCESIO works in UTC. Today and UTC Now return the UTC date and time, and a value that carries an offset (for example +02:00) is converted to UTC before an action uses it. To show a time in a local time zone, use Timezone Converter.
| Action | What it does |
|---|---|
| Today | Returns today's date (UTC), at midnight. |
| UTC Now | Returns the current date and time in UTC. |
| Is Weekend | Checks whether a date is a Saturday or a Sunday. |
| Is Weekday | Checks whether a date is between Monday and Friday. |
| Get Year | Returns the year of a date. |
| Get Month | Returns the month of a date, 1 to 12. |
| Get Day | Returns the day of the month, 1 to 31. |
| Get Hour | Returns the hour, 0 to 23. |
| Get Minute | Returns the minute, 0 to 59. |
| Get Week Number | Returns the week of the year. |
| Get Day Of Week | Returns the day of the week as a number. |
| Update DateTime | Adds or subtracts years, months, days, hours, minutes or seconds. |
| String To DateTime | Reads a date from text, with a format you give. |
| Format DateTime | Writes a date as text, in a format you write. |
| DateTime To String | Writes a date as text, in a standard format you pick. |
| Date Difference | Days, weeks, months, quarters or years between two dates. |
| Time Difference | Hours, minutes or seconds between two dates and times. |