1. Computing

Discuss in my forum

Mike Chapple

Calculating Time Periods

By January 15, 2013

Follow me on:

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!
No comments yet. Leave a Comment
Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>
  1. About.com
  2. Computing
  3. Databases

©2014 About.com. All rights reserved.