Author: Lew
Posted: 2011-04-12 at 19:46:21
Of course since we just had the once in 400 correction, none of us or any of our clients will be around to complain that mod(Year,4)=0 isn't precise enough.
Lew
-----Original Message-----
From: Paul McNett <p@ulmcnett.com>
Sender: profoxtech-bounces@leafe.com
Date: Tue, 12 Apr 2011 14:54:11
To: <profoxtech@leafe.com>
Reply-To: profox@leafe.com
Subject: Re: Testing for leap year?
On 4/12/11 2:49 PM, Lou Syracuse wrote:
> Something like this?
>
> dDate = ctod('2/28/'+<year as a string>) + 1
> if month(dDate) = 2
> ' leap year
> Else
> ' not leap year
> Endif
It isn't as simple as that. Here's the pseudocode algorithm from wikipedia:
if year modulo 400 is 0
then is_leap_year
else if year modulo 100 is 0
then not_leap_year
else if year modulo 4 is 0
then is_leap_year
else
not_leap_year
But I like Mike's TRY/CATCH approach.
Paul
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/4DA4CA03.9000806@ulmcnett.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Report [OT] Abuse: http://leafe.com/reportAbuse/4DA4CA03.9000806@ulmcnett.com
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.