Count days

  • Thread starter Thread starter Ivor Williams
  • Start date Start date
I

Ivor Williams

I have a query based on two tables. One of the fields in the query is a date
field using medium date format. The query is filtered using this field to
return records where the date field values are between a start date and an
end date. I would like to add a calculated field to count the number of days
between the start date and the end date. Not sure how to do this.

Ivor
 
The date format makes absolutely no difference in your query. Date values
are date values. Formats are for display only.

How are the start date and end date entered? Are they from controls on a
form or are they parameter prompts? Do you want total days between the
dates? Do you include both the start and end date? Do you want just work
days?

Could you provide your SQL view and possibly some sample records with
desired result?

Your answer could be as simple as a column:
DayCount:DateDiff("d",[Enter start], [Enter End])
 
Back
Top