Good day everyone. I have a query which contains a IIF() statement to find a DOB of a person on our database. I am use to using SQL and so i tried to use CAST() but that would not work.
How can I rewrite this query to equate the SQL query I have here:
CAST(floor((DateDiff(d,id.DOB,'2012-11-01')/365.25)) as INT) as AGE
This is for Access 2003