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