Count the number of days

[medranoestraaadriana]

I have a query with a starting date and an ending date. I need a day count of the total number of days. For example if the starting day is 11/01/10 and the ending day is 11/04/10, I need a formula that would give met the total number of days in these period.

Help Please.

 

[Brianwarnock]

Datediff will do that.

Brian

 

[medranoestraaadriana]

Where would I put it?, on the criteria?

 

[Brianwarnock]

Create a new field in the query

eg NumDays: Datediff("d",date1,date2)

Brian

 

[medranoestraaadriana]

It does not let me do it, I get the following error message. "This expression is typed incorrectly, or it is too complex to be evakyated"

 

[Brianwarnock]

What did you write.

Maybe you can post the SQL

Brian

 

[medranoestraaadriana]

On the field I put: NumDays

On Criteria I put: DateDiff("d","Inventory Date","Exit Date")

 

[Brianwarnock]

No, there is no criteria in the field you type

NumDays: DateDiff("d",[Inventory Date],[Exit Date])

Brian