Counting the Days

A

adam

In a query i'm tring to calculate days away
example:
[DateReturned]-[DateLeft]
But I would like to calculate [DateReturned] as Date() untill an accual date
has been entered.
 
V

Van T. Dinh

Try (the lazy way):

IIf( IsDate([DateReturned]) = False, Date(), [DateReturned]) - [DateLeft]
 
Top