Date difference

[keshava narasimha <anandthirta@xxxxxxxxxxx>]

Hi !


There was a question a few days back about finding the no .of days between 
two date fields.

It can be computed with this equation:


N = 1461 * f(year,month)/4   +  153 *g(month)/5   + day

where f(year ,month) = year-1 if month less than or equal to 2
                     = year  otherwise


where g(month) = month +13 if month less than or equal to 2
                     = month +1 otherwise


If N1 & N2 are the two date fields N= N2-N1


I tried this it works!!!!I hope this will help.


Keshav


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *