Help calculating days between dates entered

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I am running an Access 2002 database and would like my form to calcualate
the current number of days that a form is out of the office against the
current date. How do I do this?

The field I track date sent is called: [ORG_EST_TO_CLIENT_DATE] vs. [Today's
Date]

How would I get my form to do this? Thank you .
 
So simple! Thanks!

Rick B said:
=Date()-[ORG_EST_TO_CLIENT_DATE]


Rick B




s.kline said:
Hello,
I am running an Access 2002 database and would like my form to calcualate
the current number of days that a form is out of the office against the
current date. How do I do this?

The field I track date sent is called: [ORG_EST_TO_CLIENT_DATE] vs. [Today's
Date]

How would I get my form to do this? Thank you .
Click to expand...
Click to expand...
 
The other alternative to Rick's is a function called DateDiff() which
is able to work with some of the more difficult date calculations.

Cheers
Brett

Hello,
I am running an Access 2002 database and would like my form to calcualate
the current number of days that a form is out of the office against the
current date. How do I do this?

The field I track date sent is called: [ORG_EST_TO_CLIENT_DATE] vs. [Today's
Date]

How would I get my form to do this? Thank you .
Click to expand...

Cheers,
Brett
 
Hi Brett,
How would my statement look using this function?

Brett Collings said:
The other alternative to Rick's is a function called DateDiff() which
is able to work with some of the more difficult date calculations.

Cheers
Brett

Hello,
I am running an Access 2002 database and would like my form to calcualate
the current number of days that a form is out of the office against the
current date. How do I do this?

The field I track date sent is called: [ORG_EST_TO_CLIENT_DATE] vs. [Today's
Date]

How would I get my form to do this? Thank you .
Click to expand...

Cheers,
Brett
Click to expand...
 
Rick, I have a question about this statement. I would like to use this date
calcuation into a report based on estimates over 30 days. However the
calcuation only shows up on the form - how do I insert and track into a
report or query?

Thanks!

Rick B said:
=Date()-[ORG_EST_TO_CLIENT_DATE]


Rick B




s.kline said:
Hello,
I am running an Access 2002 database and would like my form to calcualate
the current number of days that a form is out of the office against the
current date. How do I do this?

The field I track date sent is called: [ORG_EST_TO_CLIENT_DATE] vs. [Today's
Date]

How would I get my form to do this? Thank you .
Click to expand...
Click to expand...
 
Look it up in Help, there's a really good set of explanations and
examples ... better than i could do at this hour of the night :)

Cheers
Brett


Hi Brett,
How would my statement look using this function?

Brett Collings said:
The other alternative to Rick's is a function called DateDiff() which
is able to work with some of the more difficult date calculations.

Cheers
Brett

Hello,
I am running an Access 2002 database and would like my form to calcualate
the current number of days that a form is out of the office against the
current date. How do I do this?

The field I track date sent is called: [ORG_EST_TO_CLIENT_DATE] vs. [Today's
Date]

How would I get my form to do this? Thank you .
Click to expand...

Cheers,
Brett
Click to expand...
Click to expand...

Cheers,
Brett
 
Back
Top