Generating system date in Query

[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.

 

[TonyN]

Neo: Try:

DateDiff("d",Date(),[DateOfDelivery])

Hope this works for you. . .

Tony N

 

[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.