How do I query for a count of days since a specific date?

[Guest]

What I'm trying to do is display the number of days that have past since the
last date (date/time format). Is this possible?

 

[Douglas J. Steele]

Use the DateDiff function:

DateDiff("d", [LastDate], Date())

 

[Guest]

Is there a calculation that can be used to automatically populate the current
date as the end date? I've heard of a get date function but am not familiar
with it.

For example:

DateDiff("d", [LastDate], [get present date])

Use the DateDiff function:

DateDiff("d", [LastDate], Date())

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

What I'm trying to do is display the number of days that have past since
the
last date (date/time format). Is this possible?

 

[Douglas J. Steele]

That's exactly what I gave you: to get the current date, you refer to the
Date() function.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Is there a calculation that can be used to automatically populate the
current
date as the end date? I've heard of a get date function but am not
familiar
with it.

For example:

DateDiff("d", [LastDate], [get present date])

Use the DateDiff function:

DateDiff("d", [LastDate], Date())

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

What I'm trying to do is display the number of days that have past
since
the
last date (date/time format). Is this possible?