Date Diff

  • Thread starter Thread starter Dan @BCBS
  • Start date Start date
D

Dan @BCBS

This expression in a query returns a date differance.
If the dates in both values are the same it returns "0" which makes sense
but is there a way to default a zero to "1"?
Another words is an appeal is opened and closed the same day I need this to
return "1".

Appeals: DateDiff('d',[received],[closed])

thanks
 
Appeals:
IIF(DateDiff('d',[received],[closed])=0,1,DateDiff('d',[received],[closed]))
 
Perfect
Thanks




KARL DEWEY said:
Appeals:
IIF(DateDiff('d',[received],[closed])=0,1,DateDiff('d',[received],[closed]))

--
KARL DEWEY
Build a little - Test a little


Dan @BCBS said:
This expression in a query returns a date differance.
If the dates in both values are the same it returns "0" which makes sense
but is there a way to default a zero to "1"?
Another words is an appeal is opened and closed the same day I need this to
return "1".

Appeals: DateDiff('d',[received],[closed])

thanks
Click to expand...
Click to expand...
 
Back
Top