Query Criteria to Display Current Week Only

[liirge]

Hello all,


I have a database that lists jobs that need doing, in the jobs table there is a Deadline field, this is a Date Time field that specifies when a job must be finished by.

So I'm trying to make a query, using my limited knowledge, that displays all jobs that need finishing between todays date and the rest of the week.

So I tried this and got nowhere:

Between #(Date())# AND #(Date()+7)#

I hope this makes sense,

Thanks in Advance

[jzwp11]

If the deadline field includes the time component, you might try to strip off the time component using the datevalue() function:

datevalue(deadline) BETWEEN date() and dateadd("d",7,date())

[liirge]

Hey again,
Thanks for the reply, the deadline does not include a time component

[liirge]

Also I don't know if im doing it wrong but that formula runs a

'Data Type Mismatch in Criteria expression' error

[liirge]

Anyone who is looking for the answer to this:

DatePart("ww",[Deadline])=DatePart("ww",Date()) And Year([Deadline])=Year(Date())