Difference betwee two dates in Months

simha_it · New User Joined: 05 May 2005 Posts: 30

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 · Posted: Mon Apr 12, 2010 9:25 pm

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

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

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