Shouldn't it be

yyyy MOD 4 EQ 0
or
yyyy % 4 = 0

I've taken note of the irregularity in case someone generates financial
forecasts for the next 100 years and asks me why 1 cent is missing (And
please don't take the present value of 1 cent in a hundred years time into
account).

-----Original Message-----
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
Behalf Of Dale Fraser
Sent: Wednesday, 9 August 2006 5:43 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Financial Year and Leap Year



FYI

MOD yyyy 4 EQ 0

Is not the correct calculation for a leap year, there is more to it

1. Years divisible by four are leap years, unless...
2. Years also divisible by 100 are not leap years, except...
3. Years divisible by 400 are leap years.

Ie: 2100 is not a leap year.

Regards
Dale Fraser

http://dale.fraser.id.au





-----Original Message-----
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Wednesday, 9 August 2006 16:47 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Financial Year and Leap Year


Steve,

You're funny...


Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273

-----Original Message-----
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Steve Onnis
Sent: Wednesday, 9 August 2006 4:42 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Financial Year and Leap Year


or....


MOD yyyy 4 EQ 0










--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---

Reply via email to