Date Query (1 Viewer)

[f.bruc]

What expression do you need to enter for:
searching records with a date before the current date?
searching records with a date which is either the current or future date?

Thanks

 

[namliam]

Date() returns the current date

Welcome to the forums

 

[f.bruc]

i realise that that returns the current date however i was wanting to know how i use that to search for previous dates and dates which are the current and future? two seperate queries.

Thanks

 

[namliam]

< Date() for history
>= Date() for today and future

?? That the answer you are looking for??

 

[gwhizz]

You need 2 queries..

SELECT Table1.date1
FROM Table1
WHERE (Table1.date1)>=Date();

SELECT Table1.date1
FROM Table1
WHERE (Table1.date1)<Date();

Gary

 

[f.bruc]

thankyou for your help, problem solved!