date calculations

K

KellyL

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
 
J

John Spencer

Perhaps

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

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