R
rleblanc
I have a report in which I calculate the client's ages. That is fine. But in
the final report I only want to list clients that are 62 or older. How can I
tell the report that I want only those 62 and older. (Age is calculated from
DOB and works just fine.)
=DateDiff("yyyy", [DOB], Date()) - IIF(Format([DOB], "mmdd") >
Format(Date(), "mmdd"), 1, 0)
Thanks!
the final report I only want to list clients that are 62 or older. How can I
tell the report that I want only those 62 and older. (Age is calculated from
DOB and works just fine.)
=DateDiff("yyyy", [DOB], Date()) - IIF(Format([DOB], "mmdd") >
Format(Date(), "mmdd"), 1, 0)
Thanks!