how to find difference between 2 dates in EZtrv

sant532 · New User Joined: 02 Jun 2008 Posts: 48 Location: India

Hi All,

Is there any built in function in Easytrieve to find the difference between 2 dates in DAYS.

enrico-sorichetti · Posted: Wed Sep 16, 2009 12:48 pm

search the forums for "easytrieve date" You might find a few hints ...
( DATECONV and friends )

sant532 · New User Joined: 02 Jun 2008 Posts: 48 Location: India

*******B006 MACRO SYSTEM - PDS , ERROR IN MACRO FILE
%DAYSCALC 031009 MMDDYY 031509 MMDDYY WH-100-TOT

I used above syntax but am getting
*******B006 MACRO SYSTEM - PDS , ERROR IN MACRO FILE

Please help!

enrico-sorichetti · Posted: Wed Sep 16, 2009 2:27 pm

there are some topics in the forums on easytrieve macro errors..
but the best thing would be to ask Your support

Anuj Dhawan · Posted: Wed Sep 16, 2009 3:36 pm

Anuj Dhawan · Posted: Wed Sep 16, 2009 3:41 pm

1. Few date Macros are available with 'Easytreive addons' (which ofcourse are paid ones). And it seems you are not lucky enough...

2. Actually, You can use the programming function of EZT to calculate the difference between two dates. A small table of the number of days in each month would be a good starting point. The complexity increases if you have large multi-year spans and you really want a high degree of accuracy as you need to account for leap years.

dick scherrer · Posted: Wed Sep 16, 2009 9:11 pm

Hello,

Many organizations have callable routines that provide "date arithmetic". You might ask your seniors or someone in technical support if such routines are already available on the system.

If none already exist, you might consider creating a common callable COBOL routine to return the difference in days between 2 dates.

Anuj Dhawan · Posted: Fri Sep 18, 2009 12:19 pm

Searching forum is not that tough, you know... ibmmainframes.com/viewtopic.php?t=26240&highlight=difference