You can use the datediff function to check the difference between the
qualification date an now.
Bill <[EMAIL PROTECTED]> wrote: Quick question is there a simple
expression I can use to tell if a date
is 5 years old i.e. I have a date field when a qualification was
attained but want to run a query to flag dates that have expired I am
thinking something like taking the date in the field adding 5 years and
have it greater or less than Date() any thoughts ? Thanks in advance
Bill
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
[Non-text portions of this message have been removed]
