The Date functions action allows you to do "date math" - for example, determining how many days separate two given dates.
In each function, there are parameters to specify the source of the date. Since this can be stored in a variety of different places within Method, a dropdown is provided to locate where the date is stored. This can range from a date being manually put in, to dates being stored in action results or controls on screen.
Each date function asks where to store the result, and, unless otherwise specified, the returned date is formatted as
M/D/YYYY H:MM:SS xM
(e.g. 6/5/2017 9:00:00 am).
Since storing the function action result is the same for every date function, it will not be explicitly called out.
Format Date
Function Result: the date in the selected format.
Parameter | Description |
Using this date | The date to format |
Format The Date to | Given a date of Feb 27, 2016, here are the following date format options available:
|
Extract from Date Functions (7 functions)
There are a 9 functions where you can return a specific date element of a given date.
Year: returns the full year
Month: returns the month using one of four formats:
Short (e.g.Jun)
Long (e.g. June)
MM (e.g. 06)
M (e.g. 6)
Day: returns the day using one of four formats:
Short (e.g.Mon)
Long (e.g. Monday)
dd (e.g. 02)
d (e.g. 2)
Hour: returns the hour in 12 hour format or 24 hour format
Minute: returns the minutes
Day of Week: returns the day of the week (e.g. Monday)
Day of Year: returns the numerical day of the year
Extract First or Last Day (8 functions)
The following functions will return either the first day (e.g. 4/1/1988 12:00:00 AM) or last day (e.g. 4/30/1988 12:00:00 AM) of the following:
First Day of Week
Last Day of Week
First Day of Month
Last Day of Month
First Day of Quarter
Last Day of Quarter
First Day of Year
Last Day of Year
Other Date for Day
Function Result: a date within a specified range of a given date
Description | |
Using this date | The original date. |
Return This | Find a day of the week after or before the original date:
|
Add to Date Functions (5 functions)
There are 5 different functions where you can add a specific time to a given date.
Add Years
Add Months
Add Days
Add Hours
Add Minutes
Date Difference
Function Result: the difference between two dates.
Description | |
Subtract This Date | The JSON text to parse. |
From This Date | The key to reference the value. |
Calculate Difference In | Difference can be calculated in:
|
NOTE: A single tick represents one hundred nanoseconds or one ten-millionth of a second. There are 10,000 ticks in a millisecond, or 10 million ticks in a second.
Convert to UTC
Function Returns: the date in UTC.
Description | |
Convert this date | The date to convert. |