Calculate Number Of Days

[lhooker]

I have a table with three (3) dates. The dates are 'Start_Date', 'End_Date' and 'Due_Date'. I want calculate the difference between 'End_Date' and 'Due_Date' in number of days in a query. Can this be done in a query ?

 

[Brianwarnock]

Did you try end_date-due_date or use Datediff, which date will normally be the later?

Brian

 

[lhooker]

Brian,

I calculated the overdue in the query (i.e. subtracted 'End_Date from 'Due_Date'). Thanks for the information ! ! !