Date Helper Toolkit
The Date Helper Toolkit is a workflow node. Its tools include Get Current Date, Format Date, Extract Date Parts, and Date Difference, plus 5 more listed below. These tools run in the workflow and do not use a third-party account. Type @ in a field when the value should come from an earlier step.
Authentication
Date Helper tools do not use a connected third-party account. Add the node to the workflow and set the fields on the tool.
Tools
Get Current Date
Retrieves current date.
| Field | Required | Description |
|---|---|---|
| Format | No | Output date format. Allowed values: DDD MMM DD YYYY HH:mm:ss, DDD MMM DD HH:mm:ss YYYY, MMMM DD YYYY HH:mm:ss, MMMM DD YYYY, MMM DD YYYY, YYYY-MM-DDTHH:mm:ss, YYYY-MM-DD HH:mm:ss, YYYY-MM-DD, MM/DD/YYYY HH:mm:ss, MM/DD/YYYY, DD/MM/YYYY HH:mm:ss, DD/MM/YYYY, DD.MM.YYYY HH:mm:ss, DD.MM.YYYY, HH:mm:ss, h:mm:ss A. Default is YYYY-MM-DD HH:mm:ss. Type @ to select a variable. |
| Timezone | No | Timezone. Allowed values: UTC, America/New_York, America/Chicago, America/Denver, America/Los_Angeles, America/Anchorage, America/Adak, Pacific/Honolulu, America/Toronto, America/Vancouver, America/Mexico_City, America/Sao_Paulo, America/Argentina/Buenos_Aires, Europe/London, Europe/Paris, Europe/Berlin, Europe/Rome, Europe/Madrid, Europe/Amsterdam, Europe/Brussels, Europe/Vienna, Europe/Warsaw, Europe/Stockholm, Europe/Athens, Europe/Istanbul, Europe/Moscow, Africa/Cairo, Africa/Johannesburg, Africa/Lagos, Africa/Nairobi, Asia/Dubai, Asia/Karachi, Asia/Kolkata, Asia/Dhaka, Asia/Bangkok, Asia/Singapore, Asia/Hong_Kong, Asia/Shanghai, Asia/Tokyo, Asia/Seoul, Australia/Sydney, Australia/Melbourne, Australia/Brisbane, Australia/Perth, Pacific/Auckland, Pacific/Fiji. Default is UTC. Type @ to select a variable. |
Format Date
Runs the format date tool.
| Field | Required | Description |
|---|---|---|
| Date String | Yes | The date string to format. Type @ to select a variable. |
| Input Format | No | Input date format. Note: currently auto-detection is always used; this field is available for future explicit format parsing. Allowed values: auto, DDD MMM DD YYYY HH:mm:ss, YYYY-MM-DD HH:mm:ss, YYYY-MM-DD, MM/DD/YYYY HH:mm:ss, MM/DD/YYYY, DD/MM/YYYY HH:mm:ss, DD/MM/YYYY, YYYY-MM-DDTHH:mm:ss. Default is auto. Type @ to select a variable. |
| Output Format | No | Output date format. Allowed values: DDD MMM DD YYYY HH:mm:ss, DDD MMM DD HH:mm:ss YYYY, MMMM DD YYYY HH:mm:ss, MMMM DD YYYY, MMM DD YYYY, YYYY-MM-DDTHH:mm:ss, YYYY-MM-DD HH:mm:ss, YYYY-MM-DD, MM/DD/YYYY HH:mm:ss, MM/DD/YYYY, DD/MM/YYYY HH:mm:ss, DD/MM/YYYY, DD.MM.YYYY HH:mm:ss, DD.MM.YYYY, HH:mm:ss, h:mm:ss A. Default is YYYY-MM-DD HH:mm:ss. Type @ to select a variable. |
| Input Timezone | No | Input timezone. Allowed values: UTC, America/New_York, America/Chicago, America/Denver, America/Los_Angeles, America/Anchorage, America/Adak, Pacific/Honolulu, America/Toronto, America/Vancouver, America/Mexico_City, America/Sao_Paulo, America/Argentina/Buenos_Aires, Europe/London, Europe/Paris, Europe/Berlin, Europe/Rome, Europe/Madrid, Europe/Amsterdam, Europe/Brussels, Europe/Vienna, Europe/Warsaw, Europe/Stockholm, Europe/Athens, Europe/Istanbul, Europe/Moscow, Africa/Cairo, Africa/Johannesburg, Africa/Lagos, Africa/Nairobi, Asia/Dubai, Asia/Karachi, Asia/Kolkata, Asia/Dhaka, Asia/Bangkok, Asia/Singapore, Asia/Hong_Kong, Asia/Shanghai, Asia/Tokyo, Asia/Seoul, Australia/Sydney, Australia/Melbourne, Australia/Brisbane, Australia/Perth, Pacific/Auckland, Pacific/Fiji. Default is UTC. Type @ to select a variable. |
| Output Timezone | No | Output timezone. Allowed values: UTC, America/New_York, America/Chicago, America/Denver, America/Los_Angeles, America/Anchorage, America/Adak, Pacific/Honolulu, America/Toronto, America/Vancouver, America/Mexico_City, America/Sao_Paulo, America/Argentina/Buenos_Aires, Europe/London, Europe/Paris, Europe/Berlin, Europe/Rome, Europe/Madrid, Europe/Amsterdam, Europe/Brussels, Europe/Vienna, Europe/Warsaw, Europe/Stockholm, Europe/Athens, Europe/Istanbul, Europe/Moscow, Africa/Cairo, Africa/Johannesburg, Africa/Lagos, Africa/Nairobi, Asia/Dubai, Asia/Karachi, Asia/Kolkata, Asia/Dhaka, Asia/Bangkok, Asia/Singapore, Asia/Hong_Kong, Asia/Shanghai, Asia/Tokyo, Asia/Seoul, Australia/Sydney, Australia/Melbourne, Australia/Brisbane, Australia/Perth, Pacific/Auckland, Pacific/Fiji. Default is UTC. Type @ to select a variable. |
Extract Date Parts
Runs the extract date parts tool.
| Field | Required | Description |
|---|---|---|
| Date String | Yes | The date string to extract parts from. Type @ to select a variable. |
| Timezone | No | Timezone for the date. Allowed values: UTC, America/New_York, America/Chicago, America/Denver, America/Los_Angeles, America/Anchorage, America/Adak, Pacific/Honolulu, America/Toronto, America/Vancouver, America/Mexico_City, America/Sao_Paulo, America/Argentina/Buenos_Aires, Europe/London, Europe/Paris, Europe/Berlin, Europe/Rome, Europe/Madrid, Europe/Amsterdam, Europe/Brussels, Europe/Vienna, Europe/Warsaw, Europe/Stockholm, Europe/Athens, Europe/Istanbul, Europe/Moscow, Africa/Cairo, Africa/Johannesburg, Africa/Lagos, Africa/Nairobi, Asia/Dubai, Asia/Karachi, Asia/Kolkata, Asia/Dhaka, Asia/Bangkok, Asia/Singapore, Asia/Hong_Kong, Asia/Shanghai, Asia/Tokyo, Asia/Seoul, Australia/Sydney, Australia/Melbourne, Australia/Brisbane, Australia/Perth, Pacific/Auckland, Pacific/Fiji. Default is UTC. Type @ to select a variable. |
Date Difference
Runs the date difference tool.
| Field | Required | Description |
|---|---|---|
| Start Date | Yes | Start date string. Type @ to select a variable. |
| End Date | Yes | End date string. Type @ to select a variable. |
| Unit | No | Unit of difference (seconds, minutes, hours, days, weeks, months, years). Allowed values: seconds, minutes, hours, days, weeks, months, years. Default is days. Type @ to select a variable. |
| Timezone | No | Timezone for dates. Allowed values: UTC, America/New_York, America/Chicago, America/Denver, America/Los_Angeles, America/Anchorage, America/Adak, Pacific/Honolulu, America/Toronto, America/Vancouver, America/Mexico_City, America/Sao_Paulo, America/Argentina/Buenos_Aires, Europe/London, Europe/Paris, Europe/Berlin, Europe/Rome, Europe/Madrid, Europe/Amsterdam, Europe/Brussels, Europe/Vienna, Europe/Warsaw, Europe/Stockholm, Europe/Athens, Europe/Istanbul, Europe/Moscow, Africa/Cairo, Africa/Johannesburg, Africa/Lagos, Africa/Nairobi, Asia/Dubai, Asia/Karachi, Asia/Kolkata, Asia/Dhaka, Asia/Bangkok, Asia/Singapore, Asia/Hong_Kong, Asia/Shanghai, Asia/Tokyo, Asia/Seoul, Australia/Sydney, Australia/Melbourne, Australia/Brisbane, Australia/Perth, Pacific/Auckland, Pacific/Fiji. Default is UTC. Type @ to select a variable. |
Add Subtract Date
Adds subtract date.
| Field | Required | Description |
|---|---|---|
| Date String | Yes | The base date string. Type @ to select a variable. |
| Input Format | No | Input date format. Note: currently auto-detection is always used; this field is available for future explicit format parsing. Allowed values: auto, DDD MMM DD YYYY HH:mm:ss, DDD MMM DD HH:mm:ss YYYY, MMMM DD YYYY HH:mm:ss, MMMM DD YYYY, MMM DD YYYY, YYYY-MM-DDTHH:mm:ss, YYYY-MM-DD HH:mm:ss, YYYY-MM-DD, MM-DD-YYYY, MM/DD/YYYY HH:mm:ss, MM/DD/YYYY, MM/DD/YY, DD-MM-YYYY, DD/MM/YYYY HH:mm:ss, DD/MM/YYYY, DD/MM/YY, DD.MM.YYYY HH:mm:ss, DD.MM.YYYY, HH:mm:ss, h:mm:ss A, X. Default is auto. Type @ to select a variable. |
| Operation | No | Operation to perform (add or subtract). Allowed values: add, subtract. Default is add. Type @ to select a variable. |
| Value | Yes | Amount to add/subtract. |
| Unit | No | Time unit (seconds, minutes, hours, days, weeks, months, years). Allowed values: seconds, minutes, hours, days, weeks, months, years. Default is days. Type @ to select a variable. |
| Output Format | No | Output date format. Allowed values: DDD MMM DD YYYY HH:mm:ss, DDD MMM DD HH:mm:ss YYYY, MMMM DD YYYY HH:mm:ss, MMMM DD YYYY, MMM DD YYYY, YYYY-MM-DDTHH:mm:ss, YYYY-MM-DD HH:mm:ss, YYYY-MM-DD, MM-DD-YYYY, MM/DD/YYYY HH:mm:ss, MM/DD/YYYY, MM/DD/YY, DD-MM-YYYY, DD/MM/YYYY HH:mm:ss, DD/MM/YYYY, DD/MM/YY, DD.MM.YYYY HH:mm:ss, DD.MM.YYYY, HH:mm:ss, h:mm:ss A, X. Default is YYYY-MM-DD HH:mm:ss. Type @ to select a variable. |
| Timezone | No | Timezone. Allowed values: UTC, America/New_York, America/Chicago, America/Denver, America/Los_Angeles, America/Anchorage, America/Adak, Pacific/Honolulu, America/Toronto, America/Vancouver, America/Mexico_City, America/Sao_Paulo, America/Argentina/Buenos_Aires, Europe/London, Europe/Paris, Europe/Berlin, Europe/Rome, Europe/Madrid, Europe/Amsterdam, Europe/Brussels, Europe/Vienna, Europe/Warsaw, Europe/Stockholm, Europe/Athens, Europe/Istanbul, Europe/Moscow, Africa/Cairo, Africa/Johannesburg, Africa/Lagos, Africa/Nairobi, Asia/Dubai, Asia/Karachi, Asia/Kolkata, Asia/Dhaka, Asia/Bangkok, Asia/Singapore, Asia/Hong_Kong, Asia/Shanghai, Asia/Tokyo, Asia/Seoul, Australia/Sydney, Australia/Melbourne, Australia/Brisbane, Australia/Perth, Pacific/Auckland, Pacific/Fiji. Default is UTC. Type @ to select a variable. |
Compare Dates
Runs the compare dates tool.
| Field | Required | Description |
|---|---|---|
| Date1 | Yes | First date string. Type @ to select a variable. |
| Date2 | Yes | Second date string. Type @ to select a variable. |
| Timezone | No | Timezone for dates. Allowed values: UTC, America/New_York, America/Chicago, America/Denver, America/Los_Angeles, America/Anchorage, America/Adak, Pacific/Honolulu, America/Toronto, America/Vancouver, America/Mexico_City, America/Sao_Paulo, America/Argentina/Buenos_Aires, Europe/London, Europe/Paris, Europe/Berlin, Europe/Rome, Europe/Madrid, Europe/Amsterdam, Europe/Brussels, Europe/Vienna, Europe/Warsaw, Europe/Stockholm, Europe/Athens, Europe/Istanbul, Europe/Moscow, Africa/Cairo, Africa/Johannesburg, Africa/Lagos, Africa/Nairobi, Asia/Dubai, Asia/Karachi, Asia/Kolkata, Asia/Dhaka, Asia/Bangkok, Asia/Singapore, Asia/Hong_Kong, Asia/Shanghai, Asia/Tokyo, Asia/Seoul, Australia/Sydney, Australia/Melbourne, Australia/Brisbane, Australia/Perth, Pacific/Auckland, Pacific/Fiji. Default is UTC. Type @ to select a variable. |
Is Valid Date
Runs the is valid date tool.
| Field | Required | Description |
|---|---|---|
| Date String | Yes | The date string to validate. Type @ to select a variable. |
| Format | No | Expected date format (or 'auto' for automatic detection). Allowed values: auto, DDD MMM DD YYYY HH:mm:ss, YYYY-MM-DD HH:mm:ss, YYYY-MM-DD, MM/DD/YYYY HH:mm:ss, MM/DD/YYYY, DD/MM/YYYY HH:mm:ss, DD/MM/YYYY, YYYY-MM-DDTHH:mm:ss. Default is auto. Type @ to select a variable. |
Next Day Of Week
Runs the next day of week tool.
| Field | Required | Description |
|---|---|---|
| Weekday | Yes | The weekday to get the next occurrence of. Allowed values: Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday. Type @ to select a variable. |
| Time | No | Time in 24h format (HH:mm). Default is 00:00. Type @ to select a variable. |
| Use Current Time | No | Use current time instead of specified time. Default is false. |
| Output Format | No | Output date format. Allowed values: DDD MMM DD YYYY HH:mm:ss, DDD MMM DD HH:mm:ss YYYY, MMMM DD YYYY HH:mm:ss, MMMM DD YYYY, MMM DD YYYY, YYYY-MM-DDTHH:mm:ss, YYYY-MM-DD HH:mm:ss, YYYY-MM-DD, MM/DD/YYYY HH:mm:ss, MM/DD/YYYY, DD/MM/YYYY HH:mm:ss, DD/MM/YYYY, DD.MM.YYYY HH:mm:ss, DD.MM.YYYY, HH:mm:ss, h:mm:ss A. Default is YYYY-MM-DD HH:mm:ss. Type @ to select a variable. |
| Timezone | No | Timezone. Allowed values: UTC, America/New_York, America/Chicago, America/Denver, America/Los_Angeles, America/Anchorage, America/Adak, Pacific/Honolulu, America/Toronto, America/Vancouver, America/Mexico_City, America/Sao_Paulo, America/Argentina/Buenos_Aires, Europe/London, Europe/Paris, Europe/Berlin, Europe/Rome, Europe/Madrid, Europe/Amsterdam, Europe/Brussels, Europe/Vienna, Europe/Warsaw, Europe/Stockholm, Europe/Athens, Europe/Istanbul, Europe/Moscow, Africa/Cairo, Africa/Johannesburg, Africa/Lagos, Africa/Nairobi, Asia/Dubai, Asia/Karachi, Asia/Kolkata, Asia/Dhaka, Asia/Bangkok, Asia/Singapore, Asia/Hong_Kong, Asia/Shanghai, Asia/Tokyo, Asia/Seoul, Australia/Sydney, Australia/Melbourne, Australia/Brisbane, Australia/Perth, Pacific/Auckland, Pacific/Fiji. Default is UTC. Type @ to select a variable. |
Next Day Of Year
Runs the next day of year tool.
| Field | Required | Description |
|---|---|---|
| Month | Yes | The month. Allowed values: January, February, March, April, May, June, July, August, September, October, November, December. Type @ to select a variable. |
| Day | Yes | Day of the month (1-31). |
| Time | No | Time in 24h format (HH:mm). Default is 00:00. Type @ to select a variable. |
| Use Current Time | No | Use current time instead of specified time. Default is false. |
| Output Format | No | Output date format. Allowed values: DDD MMM DD YYYY HH:mm:ss, DDD MMM DD HH:mm:ss YYYY, MMMM DD YYYY HH:mm:ss, MMMM DD YYYY, MMM DD YYYY, YYYY-MM-DDTHH:mm:ss, YYYY-MM-DD HH:mm:ss, YYYY-MM-DD, MM/DD/YYYY HH:mm:ss, MM/DD/YYYY, DD/MM/YYYY HH:mm:ss, DD/MM/YYYY, DD.MM.YYYY HH:mm:ss, DD.MM.YYYY, HH:mm:ss, h:mm:ss A. Default is YYYY-MM-DD HH:mm:ss. Type @ to select a variable. |
| Timezone | No | Timezone. Allowed values: UTC, America/New_York, America/Chicago, America/Denver, America/Los_Angeles, America/Anchorage, America/Adak, Pacific/Honolulu, America/Toronto, America/Vancouver, America/Mexico_City, America/Sao_Paulo, America/Argentina/Buenos_Aires, Europe/London, Europe/Paris, Europe/Berlin, Europe/Rome, Europe/Madrid, Europe/Amsterdam, Europe/Brussels, Europe/Vienna, Europe/Warsaw, Europe/Stockholm, Europe/Athens, Europe/Istanbul, Europe/Moscow, Africa/Cairo, Africa/Johannesburg, Africa/Lagos, Africa/Nairobi, Asia/Dubai, Asia/Karachi, Asia/Kolkata, Asia/Dhaka, Asia/Bangkok, Asia/Singapore, Asia/Hong_Kong, Asia/Shanghai, Asia/Tokyo, Asia/Seoul, Australia/Sydney, Australia/Melbourne, Australia/Brisbane, Australia/Perth, Pacific/Auckland, Pacific/Fiji. Default is UTC. Type @ to select a variable. |
See all integrations on the toolkits overview.