Calculating Time Periods

In a recent forum message, a user wrote:

"Hi, I am new in the forum and also new in building databases. I need help to calculate the time between the DeliveryDate and the PODate but if DeliveryDate is blank the function should count the number of days until today.

I used the following function in the Query but it does not work: Delivery Period: iif( isEmpty([DeliveryDate]), DateDiff("ww",[DeliveryDate],Date()), DateDiff("ww", [PODate], [DeliveryDate]))

Your help will be highly appreciated!"

Can you help? Interested in answers to the same question? Visit the About Databases Forum and join the discussion!