You could stick the logic used in my reply into one line...I never thought about it too much...I use the ROLLOVER clause..
Take care,
Joe
>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
Joseph C. Kempel
Systems Analyst/Programmer
JNC