datediff(d,date1,date2) eq 366
B)
Scott Thornton wrote:
Hi,
Does anyone have a function (hopefully sql) that would return true if a date
in a financial year (01/07/xx to 31/06/yy) and there happened to be a leap
year in that period?
(Hope I explained myself okay).
Scott
nevermind.
[EMAIL PROTECTED] 09/08/2006 4:17:44 pm
Hi,
Does anyone have a function (hopefully sql) that would return true if a date in
a financial year (01/07/xx to 31/06/yy) and there happened to be a leap year in
that period?
(Hope I explained myself okay).
Scott Thornton,
or
MOD 4 EQ 0
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
Behalf Of Brett Payne-Rhodes
Sent: Wednesday, August 09, 2006 4:30 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Financial Year and Leap Year
datediff(d,date1,date2) eq 366
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Financial Year and Leap Year
or
MOD 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
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
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 4 EQ 0
Is not the correct calculation for a leap year, there is more