Generating system date in Query

N

Neo

hello all,
I have an inventory/ stock database where one field includes a date of
delivery field. for my query i would like to input the expression to check if
the date of delivery is greater than 18 days from the current date it would
display those records. could someone provide guidence on how to state the
expression?
PS i was thinking it would automatically compare the date of delivery with
the current (computer) system date. do i need to create a table for the
system date in the query? i was working on this formular:
DateDiff("d",[DateOfDelivery],[Date])>18 but it asks me to input the
date which i DONT want.
 
J

John W. Vinson

hello all,
I have an inventory/ stock database where one field includes a date of
delivery field. for my query i would like to input the expression to check if
the date of delivery is greater than 18 days from the current date it would
display those records. could someone provide guidence on how to state the
expression?
PS i was thinking it would automatically compare the date of delivery with
the current (computer) system date. do i need to create a table for the
system date in the query? i was working on this formular:
DateDiff("d",[DateOfDelivery],[Date])>18 but it asks me to input the
date which i DONT want.

Date() - without square brackets and with parentheses - calls the builtin
function to check the system clock. Other than that your expression looks
good.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top