null dates

[legendv]

in a query I want to show usage days by subtracting the end date from the beginingdate, however sometimes the ending date isn't complete, so I want to say something like if enddate is null then date() - beginingdate. Anyone know how to do that?

 

[THoey]

You almost have the right answer. Look at the IFF and the DateDiff statements. Should be able to do:

IFF (IsNull(EndDate), DateDiff("d", Date(), StartDate), DateDiff("d", EndDate(), StartDate)) Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...