Calculating number of day in a query

[scottsoo9]

I have two dates in my table, a start date and end date. I want to be able to calculate the number of days are between the start and end date and the amount of weeks. How would I go about doing this in my query.

 

[pbaldy]

Look at the DateDiff() function in help.

 

[scottsoo9]

I am very new to this and trying to learn as much as I can but what is wrong with the way I am trying to put this in. In the field box when trying to create my query, I am typing DateDiff("d," Start Date, End Date) Is this totally off? Any help is appreciated. Thanks, Scott

 

[pbaldy]

With the inadvisable spaces in your names, you'd have to bracket them (plus the comma was inside the quotes). Try:

DateDiff("d", [Start Date], [End Date])