How to calculate the number of days between 2 dates

  • Thread starter Thread starter Jacqueline
  • Start date Start date
J

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?
 
Jacqueline said:
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?
Click to expand...


See help file for DateDiff() function.

DateDiff("d", [OlderDate], [NewerDate])
 
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!
 
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?
| >.
| >
 
Back
Top