Getting date values

[miller1975]

Hello All,
I am trying to write a query where the date value can be checked with a previous date.
Right now my code picks real date values eg:4/21/2005
But I want to have option to use previous dates..for example 3 days from today or 2 days from today..
How do I do that..

WHERE (((TEST.VALUE <> "P" AND (TEST1.VALUE <> "" AND)  ((TEST1.DATE_VALUE =#4/21/2005"));

 

[PHV]

Something like this ?
WHERE TEST.VALUE <> "P" AND TEST1.VALUE <> "" AND TEST1.DATE_VALUE = Date()-3;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Presterman]

Just adding it on works:

((TEST1.DATE_VALUE =#4/21/2005# +3));

 

[miller1975]

Date()-3 would mean current date - 3 right..
Just to confirm...

Thanks..