Calculating Time between Dates

  • Thread starter Thread starter jbc
  • Start date Start date
J

jbc

Hi,

I am working in Access 2000 and want to calculate the
number of years that a member has belonged to our
organization.

MembershipDate (date joined)
ExpirationDate (date expires)

Is there a source that explains the built-in functions for
Access?

Thanks.

jbc
 
Hi,

I am working in Access 2000 and want to calculate the
number of years that a member has belonged to our
organization.

MembershipDate (date joined)
ExpirationDate (date expires)

Is there a source that explains the built-in functions for
Access?

Thanks.

jbc
Click to expand...

YearsMember = DateDiff("yyyy",[DateJoined],Date())

You can find Help on the functions in VBA Help.
Type Function in the 'type keywords' box and click Search
 
Back
Top