HELP! calculating differences between dates 1

[Joels7]

In a query, I want to subtract dates and get the number of days between as a result, so if in a given record, end_date=9/11/01 and start_date=8/31/01, a calculation field defined by (end_date - start_date) should evaluate to 11.

How do I accomplish this without getting an error msg.

I'd rather do it if possible with a simple function rather than a VB program

thank you,

Joels

 

[lamaar]

Create a new field within the Query with the following:

Difference in days: DateDiff("d",[start_date],[end_date])

This will assign the difference in days to the field.

Lamaar75@hotmail.com