How can I select all records with dates older than 30 days. I have an access database...<BR><BR>I am using SELECT * FROM inv WHERE invDate < Date()- 30, But this does not work
I dont believe, This shd be possible.. r u sure
Sorry can u please iluustrate with an example:<BR>If I want all record whose date is more than 30 days old<BR>This way???<BR>invDate > DateDiff("d", Now, 30)???
you have to use DateAdd.<BR><BR>Why he cane be bothered to "search" how ot use dateadd on his own i dont know.<BR><BR>