Selecting between two dates

[nicorvp]

I have to select tasks from MSProject file (.mdb exported) that recurs in a given date: I could use:

... WHERE MyDate>=TASK_START_DATE AND  MyDate<=TASK_FINISH_DATE

But suppose I have a record in which:
TASK_START_DATE 21/01/2010 8.00.00
TASK_FINISH_DATE 25/01/2010 8.00.00
Quering with MyDate = 21/01/2010, I cant get this record because Access supposes that MyDate is 21/01/2010 0.00.00 that is before 8 o'clock.


I have tried rebuilding dates with DatePart, trying to remove the time part of the date, but without success
Can you help me?

[RuralGuy]

Try:
WHERE MyDate>=TASK_START_DATE AND MyDate<=TASK_FINISH_DATE+1

[nicorvp]

I think it doesnt work for me.
If I use this it would be:

WHERE 21/04/2010 0.00.00>=21/01/2010 8.00.00
AND 21/04/2010 0.00.00<=26/01/2010 8.00.00

that is false!

[RuralGuy]

I'm sorry but I misread your post. How about using DateValue?
WHERE DateValue("21/04/2010 0.00.00")>=DateValue([TASK_START_DATE])
AND DateValue("21/04/2010 0.00.00")<=DateValue([TASK_FINISH_DATE])

[nicorvp]

That's it!!!
Many thanks

[RuralGuy]

You're welcome. Are you ready to follow the link in my sig and mark this thread as Solved?