Variable Modify Date / Time

Use this command to make date and time calculations. The original date and time must be saved as a Date/Time variable in order to process the calculations.

Script Editor > Expand Variables Category > Variable Modify Date/Time

What Method Would you Like to Use?

Select the option to perform from the drop down list.

•Add - Add dates or times together.

•Subtract - Subtract dates or times from another date or time.

•Extract Day - Extract the day from the date variable and save to another variable.

•Extract Month - Extract the month from the date variable and save to another variable.

•Extract Year - Extract the year from the date variable and save to another variable.

•Extract Hour - Extract the hour from the time variable and save to another variable.

•Extract Minute - Extract the minute from the time variable and save to another variable.

•Extract Second - Extract the second from the time variable and save to another variable.

•Convert to Text Variable - Convert the Date/Time variable into a text string variable.

Add or Subtract Commands

Destination Date/Time or Decimal Variable

Insert the date/time or decimal variable to receive the result of the addition or subtraction.

Date/Time Variable

Select the date and time variable to be used as part of the calculation

Date/Time Variable - Integer Value

Insert a second date/time variable to be part of the calculation or insert an integer value. With the integer value option, the macro adds or subtracts the amount of the integer from the date or time. Select from the drop down list to add or subtract from the day, month, year, hour, minute, second or millisecond.

Extract Commands

Date/Time Variable

Select the variable from which the date or time component is to be extracted and saved to an integer variable.

Destination Integer Variable

Select the integer variable to store the value extracted from the date/time variable.

Convert to Text Variable

This option converts the date/time variable into a text string variable.

Date/Time Variable

Select the Date/Time variable to be converted to a text string variable.

Format to Convert Date/Time to:

Select the date or time format to use with the text string variable.

Text Variable to Receive Result

Select the text string variable to store the value from the date/time variable.