"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!