>Hello All,
>A simple question but one I have gone completelty blank on.
>
>How do I define a leap year?? I know that year % 4 returning a 0 is not enough. What's the rest??
>
>Thanks
Sandy,

Since everyone's giving you function ideas, here's mine:

* ldtdate is a DATE or DATETIME
lnyear = YEAR(ldtdate)
llisleap = (lnyear % 4 = 0) AND ((lnyear % 100 # 0) OR (lnyear % 400 = 0))