Date Between Query

[steveharrison]

Having problems getting the query to work returning the records that i want.

I have two date fields Job_Start and Job_Stop, these will be used in a diary system similar to the way outlook works. Therfore the job may start on one day but continue on for serveral days.

I want to pass a date to the query and have it return all the records that are still currently active on the date i have passed (between Job_start and Job_Stop).

I'm sure it is somthing to do with the BETWEEN statement but i have been trying this for hours now and just cannot get it right.

Any help pleeeeese.

 

[samehkh]

You can still use jobstart <= date AND jobstop>= date.

 

[steveharrison]

Nice one samehkh

Cant believe how simple you made it, i knew i was spending too long looking at the problem and was just making it more complex.

I wont embarass myself by admitting how long i spend on this and the number of aborted attempts.

A fresh pair of eyes and a smart mind made all the difference.

Thanks again.

Steve

 

[namliam]

Between wouldnt work in this situation....

Regards

 

[Jon K]

BETWEEN works if the date is passed to the query like this:-

Field:      [The date to pass]

Show:     uncheck
Criteria:  BETWEEN Job_Start AND Job_Stop;