Chapter 5 : Using Processes

5.3.3.Date Difference

Difference

The Date Difference process allows you to compute the number of days,

 

hours, minutes, seconds, or milliseconds between two dates.

 

To determine the period of time between two dates, proceed as follows:

 

1

Add the process Date Operation to your project and click OK

 

2

In the Value 1 box, create or select the first 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 Date Difference

 

5

In the Value 2 box, create or select a variable that contains the

 

6

second date to be used in the calculation.

 

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

 

 

you want to save the value of the difference between the dates

 

7

and click OK.

 

In the Output Format box, select unit of measure to be used to

 

8

express the difference between the two dates.

 

Click OK.

Example

The following example calculates the number of days between the

 

variable [D3] V_Ordering_Date and the variable [D4] V_Delivery_Date

 

and saves the result in a variable [D5] V_Difference.

www.mcl-collection.com

October 2007

Page 146

Copyright © 2007 • MCL Technologies • All Rights Reserved

 

 

Page 146
Image 146
Datamax v1.1x user manual Date Difference