|
View previous topic :: View next topic
|
| Author |
Message |
josepnass
New User
Joined: 31 Dec 2003
Posts: 16
Location: dc
|
|
|
|
HI all ho would you find the difference in no of months between a date 09/22/2014 and 06/20/2014 in Cobol
Thanks I am having issues just an intern
John  |
|
| Back to top |
|
 |
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3076
Location: NYC,USA
|
|
|
|
Isn't that just to take the first 2 bytes for each field, subtract and get the difference? or also you can use the intrinsic functions for DATEs.
Also, you can take the help of below link,
ibmmainframes.com/about9591.html |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8700
Location: Dubuque, Iowa, USA
|
|
|
|
You need to CLEARLY define the rules -- is a difference of 1 month and 1 day to be considered 1 month, or 2 months? how about 1 month and 29 days? how about February 28 to March 1? how about February 28 to March 1 in a leap year?
If I had to do this, depending upon the exact requirement, I would probably convert both dates to days using the intrinsic function, subtract, and divide the difference by 30 with rounding. No, that would not be exact but unless the requirement is more clearly stated. in most (but not all) cases that would be close enough.
For precision, you have to iterate from the earlier date to the later date, handling February and December / January along the way.
Most sites have date handling routines LONG established and generally if such routines are available at your site -- USE THEM. Yes, they are custom to each site, but they will provide what the site requires. |
|
| Back to top |
|
|
josepnass
New User
Joined: 31 Dec 2003
Posts: 16
Location: dc
|
|
|
|
| Its more complex that that but I see what you mean . |
|
| Back to top |
|
|
josepnass
New User
Joined: 31 Dec 2003
Posts: 16
Location: dc
|
|
|
|
| just months so ? |
|
| Back to top |
|
|
josepnass
New User
Joined: 31 Dec 2003
Posts: 16
Location: dc
|
|
|
|
| what i have states if the current date is 3 mths prior from a maturity date then I do another process based on it being 3 months.. |
|
| Back to top |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006
Posts: 1353
Location: Israel
|
|
|
|
Full (and correct) answer depends on how your dates are stored and how they are accessed.
Just as an example, if you are reading your data from a DB2 table, you could just select the interesting rows:
| Code: |
SELECT ....
FROM ...
WHERE MATURATION_DATE < (CURRENT DATE - 3 MONTH) |
|
|
| Back to top |
|
|
|
|
