Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref

Author Message
simha_it

New User

Joined: 05 May 2005
Posts: 30

 Posted: Mon Apr 12, 2010 4:39 pm    Post subject: Difference betwee two dates in Months Hi, Could you please tell me a logic to find out the number months between two dates. for ex: Date1 - 31-12-2009, Date 31-03-2010. the difference in months are: 3. Date1 - 31-12-2009, Date 18-04-2010. the difference in months are: 4. Note: if the date crossed 15th, then that will consider it as 1 month. Here date is 18th. So 3+1 = 4 Please assist me. Thanks Simha

Skolusu

Senior Member

Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

 Posted: Mon Apr 12, 2010 9:25 pm    Post subject: simha_it, Sort products do NOT have the ability of calculating the difference between 2 dates.
khannay2k

New User

Joined: 24 Feb 2005
Posts: 28
Location: Bangalore

 Posted: Tue Apr 13, 2010 12:40 pm    Post subject: Reply to: Difference betwee two dates in Months Simha, You will have to write simple logic to find out the diff. Capture the year part of date2 in ws-date2-yy, Capture the year part of date1 in ws-date1-yy. Find the diff b/w these two var ws-yr-diff = (ws-date2-yy - ws-date1-yy) Capture the month part of date2 in ws-date2-mm, Capture the year part of date1 in ws-date1-mm. Find the diff b/w these two var ws-mm-diff = (ws-date2-mm - ws-date1-mm) Capture the day part of date2 in ws-date2-dd. If ws-date2-dd < 16 ws-diffmm = ws-yr-diff *12 + ws-mm-diff -1 else ws-diffmm = ws-yr-diff *12 + ws-mm-diff Hope this helps. khanna
khannay2k

New User

Joined: 24 Feb 2005
Posts: 28
Location: Bangalore

 Posted: Tue Apr 13, 2010 12:48 pm    Post subject: Reply to: Difference betwee two dates in Months Simha, I am sorry slight change in the code, month part of date2 can be < month part of date1, so Capture the year part of date2 in ws-date2-yy, Capture the year part of date1 in ws-date1-yy. Find the diff b/w these two var ws-yr-diff = (ws-date2-yy - ws-date1-yy) Capture the month part of date2 in ws-date2-mm, Capture the year part of date1 in ws-date1-mm. ws-mm-diff = (ws-date2-mm + ws-yr-diff * 12 - ws-date1-mm) Capture the day part of date2 in ws-date2-dd. If ws-date2-dd < 16 ws-mm-diff = ws-mm-diff - 1 Hope this helps. khanna
 All times are GMT + 6 Hours
 Page 1 of 1

Search our Forum:

 Topic Author Forum Replies Posted Similar Topics Difference between EQUAL and EQUAL TO... jithinraghavan COBOL Programming 3 Thu Apr 19, 2018 2:22 am ISMF Difference between volume count ... upendrasri IBM Tools 2 Tue Dec 05, 2017 12:40 pm Comparing dates in different formats migusd SYNCSORT 4 Sat Nov 18, 2017 3:02 am Finding difference between two PS fil... Vignesh Sid SYNCSORT 5 Mon Oct 30, 2017 1:13 pm Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm

 © 2003-2017 IBM MAINFRAME Software Support Division
 Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us