Actions: Date/Time
Add Value to Date
Outputs the sum of a value and a date into the selected format.
Argument | Description |
---|---|
Output | The location of the output of both the value and the date (variable or text or field element). |
OutputFormat | The desired format for the sum of the value and the date in either: ‘MM/DD/YYYY’ or ‘DD/MM/YYYY’. |
Date | The location where the date is located (variable or text or field element). |
DateFormat | The format of the date being summed. |
Value | The value added to the date. |
ValueType | The type of value being added to the date in either: day, month, or year. |
Check Date Range
Determines if the date falls within the specified range. Range includes the start date and end date (inclusively bound).
Argument | Description |
---|---|
Output | An output statement specifying whether the Date is ‘within’, ‘below’, or ‘above’ the range. |
Date | The location of the date to check whether it falls within the start date and end date (variable or text or field element). |
StartDate | The start date of the range. |
EndDate | The finish date of the range. |
DateFormat | The collective formatting of the date, start date, and end date as either: ‘MM/DD/YYYY’ or ‘DD/MM/YYYY’. |
Compare Dates
Determines if the date is before or after the date being compared to.
Argument | Description |
---|---|
Output | An output statement specifying whether the Date ‘Occurs Before’ or ‘Occurs After’ the compared date. Otherwise they are the ‘Same Date’. |
Date | The date being compared with (variable or text or field element). |
DateFormat | The format of the date being compared with. |
ComparedDate | The date being compared to. |
ComparedDateFormat | The format of the other date. |
Convert Date
Converts date into the selected format.
Argument | Description |
---|---|
Input | The location of the date that will be converted (variable or text or field element). |
InputFormat | The current format of the date. |
Output | The location where the converted date will go (variable or text or field element). |
OutputFormat | The desired format for the date. |
Convert DateTime
Converts the date and time into the selected format.
Argument | Description |
---|---|
OutputTimeFormat | The desired format for the time. |
Input | The location of the date and time that will be converted (variable or text or field element). |
InputDateFormat | The current format of the date. |
Output | The location where the converted date and time will go (variable or text or field element). |
OutputDateFormat | The desired format for the date. |
Convert Month
Converts a line-delimited list of months to the specified format.
Argument | Description |
---|---|
Output | The location where the converted month or list of months will go (variable or text or field element). |
Input | The variable or text or field element that contains a line-delimited list of month names or numbers. |
Format | The desired format for the month(s). |
Convert Time
Converts time into the selected format.
Argument | Description |
---|---|
Input | The location of the time that will be converted (variable or text or field element). |
InputFormat | The current format of the time. |
Output | The location where the converted time will go (variable or text or field element). |
OutputFormat | The desired format for the time. |
Find Day of Week
Outputs the day of the week based on the date given.
Argument | Description |
---|---|
Date | The location where the date is located (input, variable or text or field element). |
DateFormat | The format of the date. |
Output | The output location of the day of the week based on the given date (variable or text or field element). |
Abbreviation | Optional parameter to abbreviate the outputted day of the week. |
Get the Current Date and Time
Retrieves the current date and time in the selected format.
Argument | Description |
---|---|
Output | The location where the date and time will go (variable or text or field element). |
DateFormat | The desired format for the date. |
TimeFormat | The desired format for the time. |
Get the Current Time
Retrieves the current time in the selected format.
Argument | Description |
---|---|
Format | The desired format for the time. |
Output | The location where the formatted time will go (variable or text or field element). |
Get the Date
Retrieves the current date in the selected format.
Argument | Description |
---|---|
Format | The desired format for the date. |
Output | The location where the result will go (variable or text or field element). |
Subtract Value From Date
Outputs the result of subtracting a value from the specified date into the selected format.
Argument | Description |
---|---|
Output | The location of the output after subtracting the value from the date (variable or text or field element). |
OutputFormat | The desired format for the difference of the value and the date in either: ‘MM/DD/YYYY’ or ‘DD/MM/YYYY’. |
Date | The location where the date is located (variable or text or field element). |
DateFormat | The format of the date. |
Value | The value subtracted from the date. |
ValueType | The type of value subracted from the date in either: day, month, or year. |
Validate Date
Determines if the date is valid and returns an output of true or false.
Argument | Description |
---|---|
Output | A binary ‘true’ or ‘false’ statement specifying whether the date is valid. |
Date | The date being validated(variable or text or field element). |
DateFormat | The format of the date being validated. |
This chapter was last updated on Wed 8 Feb 2023 14:24:05 GMT