How to calculate the number of days between 2 dates

[Jacqueline]

I have a Study Submitted date field (format: dd/mm/yyyy)
and a Study Approved Date field...how do I calculate the
# of days between these 2 dates?

 

[Rick Brandt]

I have a Study Submitted date field (format: dd/mm/yyyy)
and a Study Approved Date field...how do I calculate the
# of days between these 2 dates?

See help file for DateDiff() function.

DateDiff("d", [OlderDate], [NewerDate])

 

[Guest]

I need to create a report based on this query which shows
the # of days it took for a study to go from the time of
submission to the time it was approved.
For example: If Date Submitted was 01/01/2003 and Date
Approved was 15/02/2003...how would I get the number of
days between them...how does it take into account the
number of days in each month??

I'm just looking for a formula to use in a
query....THANKS!

 

[Jacques Latoison]

I'm pretty certain you just have to write the expression =[Field2]-[Field1]
keeping the field in date format.

| I need to create a report based on this query which shows
| the # of days it took for a study to go from the time of
| submission to the time it was approved.
| For example: If Date Submitted was 01/01/2003 and Date
| Approved was 15/02/2003...how would I get the number of
| days between them...how does it take into account the
| number of days in each month??
|
| I'm just looking for a formula to use in a
| query....THANKS!
|
| >-----Original Message-----
| >I have a Study Submitted date field (format: dd/mm/yyyy)
| >and a Study Approved Date field...how do I calculate the
| ># of days between these 2 dates?
| >.
| >