Posted: Wed Dec 19, 2007 8:15 am Post subject: define leap year
Year 2008 is a leap year and every 4 years Feb will have 29.
We provide contract on annual bases and the calcualtion is based on 365 days
if the period contain Feb 29 2008 then the annual contract day will be 366
days
if this is the case tell the computer it should be 365
and how can my database will recvcognize it t=in furutre leap year.
Posted: Wed Dec 19, 2007 8:55 am Post subject: Re: define leap year
Hi Klam,
This question does not appear to relate to Microsoft Word.
Having said that, a contract on annual basis should not ignore leap years - either they're 365-day contracts, or they're annual
contracts (which implicitly allow for the possibility that the terms of the contracts include 29 Feb in a leap year).
Plus, the leap year formula is a bit more complicated:
If year mod 400 = 0 then
'Leap Year'
ElseIf year mod 100 = 0 then
'Not Leap Year'
ElseIf year mod 4 = 0 then
'Leap Year'
Else
'Not Leap Year'
End If
Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------
"Klam" <Klam@discussions.microsoft.com> wrote in message news:AEBB3EB2-8AEC-4D2A-B396-33051DD6764E@microsoft.com...
Quote:
Year 2008 is a leap year and every 4 years Feb will have 29.
We provide contract on annual bases and the calcualtion is based on 365 days
if the period contain Feb 29 2008 then the annual contract day will be 366
days
if this is the case tell the computer it should be 365
and how can my database will recvcognize it t=in furutre leap year.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
