Thanks. Surely I am not the only one to come up with a one-line check, though.
>I wasn't aware of the INLIST function...
>
>This is a cool implementation of it...
>
>Joe
>
>>dDate = a Date variable
>>MOD(YEAR(dDate),4)=0 AND !(INLIST(MOD(YEAR(dDate),400),300,200,100))
>>
>>
>>>I need a function to calculate leap years. Any suggestions? Thanks,
>>>
>>>Raef
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05