define leap year

K

Klam

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.


klam
 
M

macropod

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If a date range contains a leap year (date) 14
Leap Year 3
Set Up Calendar To Account For Leap Years 2
Create dates for year, allow for leap year 8
Calculate expirate date taking into account leap year 4
Determining a leap year 20
Calculating to add years - including leap year 4
Leap Year 7

Top