subtract date in access to get age

[Guest]

I have forgotton how to subtract 2 dates in acces to get the age, has anyont
got a quickie for this??

cheers

 

[Gord Dibben]

See Chip Pearson's DATEDIF page.

http://www.cpearson.com/excel/datedif.htm

Gord Dibben Excel MVP

 

[Jamie Collins]

See Chip Pearson's DATEDIF page.

I think you meant DATEDIFF e.g.

SELECT
DATEDIFF("yyyy", birth_date, NOW()) AS age
FROM
MyTable
;

Jamie.

--