Counting Days

[jo.stanley]

HI

I have one table that has two columns with different dates. I want too run a query that will count the number of days between these two dates but I don't know what criteria I should use. I am using Access 2002

ray:

Thanks

J

 

[Corticus]

Add an expression field and subtract the smaller date from the larger date in this field. The resulting number will be the difference, in days, between the two dates.

 

[jo.stanley]

Thanks for that - Im new to Access so unfortunately I need more help. Could you give me an example of what the expression should look like and also where i put the expression.

Many thanks - from a complete novice

 

[Norie]

Use the DateDiff function in an expression.

eg DaysPassed:DateDiff("d", [FirstDate], [SecondDate])

Replace FirstDate and SecondDate with your field names.

 

[Corticus]

Start a new query in design view.

Add the table that has the two dates you need to see the difference between. Add in whatever fields you'll need to see down the road from this query. Add a new field, and express it like this:

DaysDiff: [date2] - [date1]
where date2 and date1 are the names of the fields holding your date values. When the query is viewed, you will see a new field, named 'daysDiff' (which is arbitrary, you can name it anything) with a value representing the # of days between date2 and date1. It is not necessary to use the datediff() function in this case, as you are just looking for the number of days between two dates.