datediff problem

[dseeburg]

Ok so im making a query that will select all the job postings from my database posted in the last 4 weeks. I dont want to hard code the exact date in as it wouldnt be the same tomorrow. Ive tried different variations of datediff() using the Now() function but i cant seem to get it right...any ideas on what im doing wrong?

[jzwp11]

Welcome to the forum

If you want to return records where some date field is between today and what the date was 4 weeks ago (or 28 days ago) then I thing either one of these should work

WHERE yourdatefield between dateadd("ww",-4,date()) and date()

or

WHERE yourdatefield between dateadd("d",-28,date()) and date()



Using the datediff() function is also possible

WHERE datediff("d", yourdatefield, date())<=28
or
WHERE datediff("ww", yourdatefield, date())<=4

[dseeburg]

when you say "yourdatefield" what do you mean by that exactly, is there a way to say for instance every time the database is opened and this query is ran that it would return the job postings in a span of 4 weeks from the day the query was ran every time...each way i write it i keep coming back to...yea its right today but if i opened it in a month the date wouldnt be a span of 4 weeks prior but rather 8 weeks...im not sure if im saying this right

edit* well i came up with datediff("ww",[DatePosted], Now()) <= 4 would this work?....

edit2* nm i see thats exactly what you were saying at the bottom....thanks for your help! i really appreciate it!

[jzwp11]

It sounds like you got it worked out; good luck with your project.