leap year stuff

[shanedavid1981]

Hi people )

I'm wondering if anyone knows this, but does the leap year day in the year get numbered in sequence with the rest or does it become day 366?

I'm programming a calendar matrix on screen that will represent each block as a certain colour for whatever code is associated with it, and was going to use an array (Box1 - Box 365/366) to make the coding simpler.. just not sure how to handle February the bleedin 29th, lol!

Thanks guys!

 

[PHV]

The february 29th is always day number 60.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[shanedavid1981]

hey, thanks for a quick reply...

how would i code this in then for redundancy purposes?

for example, the normal 365 day calendar has small boxes called Box1..Box365 and i plan to use an array to read data in from a table and colour code the boxes if there is a code associated with that day...

How would I be able to tell access to include a box for feb 29th, and then i would have to change the names of the boxes after 59 for the array to work correctly...

if there is an easier way around this i would love to hear it )

Thanks PHV