Copyright © 2007 • MCL Technologies • All Rights Reserved
www.mcl-collection.com
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
variables or System variables.
3 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
second date to be used in the calculation.
6 In the Result Variable box, select or create the variable in which
you want to save the value of the difference between the dates
and click OK.
7 In the Output Format box, select unit of measure to be used to
express the difference between the two dates.
8 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.
October 2007 Page
146