Chapter 5 : Using Processes

5.3.1.Date Add/Subtract

Add/Subtract

The Date Add/Subtract process allows you to add or subtract a number

 

of days to or from a date variable (i.e. a variable that contains a date)

 

and save it in a new variable.

 

To add or subtract days to a date variable, proceed as follows:

 

1

Add the process Date Operation and click OK

 

2

In the Value 1 box, create or select the input date variable from

 

 

the available User Local variables, All Local variables, Global

 

3

variables or System variables.

 

In the Input Format box, select the format of the input date.

 

4

In the Operation box select Add/Subtract and the measure of

 

5

time (days, weeks, months, etc.)

 

In the Value 2 box, type the quantity of the given unit of measure

 

 

to add to the input variable or select a variable that contains the

 

6

value to be added or subtracted.

 

In the Result Variable box, select or create the variable in which

 

7

you want to save the resulting date and click OK.

 

In the Output Format box, select the format of the date desired in

 

8

the resulting variable.

 

Click OK.

Example

The following example takes the variable [D4] V_Delivery_Date and

 

subtracts 5 days (adds -5 days) to determine the ordering date. The

 

result is saved in the variable [D3] V_Ordering_Date.

www.mcl-collection.com

October 2007

Page 144

Copyright © 2007 • MCL Technologies • All Rights Reserved

 

 

Page 144
Image 144
Datamax v1.1x user manual Date Add/Subtract