Comparing dates

[shanky365]

Guys,
i have a query which gives me some items with expected time arrival dates. (ETA) in the store.. now, i want to get the missing items by the foll trick:
if the ETA date has passsed today's dates then that item is not in store.
so how can i compare ETA dates and today !

[alansidman]

In a new column in your query, type this expression:

DeliveryLate: IIF(Date()>[ETA],"LATE!","")

Alan

[shanky365]

In a new column in your query, type this expression:


Alan

Thanks a ton! it works!