date calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to calculate the number of days files are open in a make table
query. This provides the right number of days when the file is closed:

DateDiff("d",[CALLdate],[COMPLETEdate])

Can anyone help with this formula in cases where the file is still open
(COMPLETEdate is null) and I'd like the number of days from a date entered
via parameter.

Thanks
 
Perhaps

DateDiff("d",CallDate,NZ(CompleteDate,[What is the defaultDate?])

So if CompleteDate is null, the expression uses the date you input.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Another Crosstab query question 14
SQL Query between 2 dates 5
Setting Values to Null or False Using a Update Query 2
IIf statement in Access 2003 query 9
One report for all managers 8
Help combining code in query. 3
Creating an update query that uses multiple parameters 2
CalcWorkDays error 1

Back
Top