Query for date range from two column?

[sunny]

hi all,
In one table there is two column for date like start and end date.I wanted to find all the record between start and end date based on the condition.I have written one query but it not working.Below is my query

SELECT A.STUDY_COMPOUND, A.PROTOCOL, A.TEST_SYSTEM, A.PROTOCOL_TITLE, A.GLP_NONGLP, A.TEST_SITE, A.MASTER_TEST_FACILITY, A.WORK_FACILITY, A.MONITOR_INVESTIGATOR, A.SUPPORT_WORK_ID, A.ACTIVITY, A.WR_DISPLAY, A.WC_DISPLAY, A.WORK_STATUS, A.STUDY_DIRECTOR, A.DATE_INITIATED, A.DATE_COMPLETE, A.IN_VIVO_START, A.IN_VIVO_END, A.STUDY_STATUS, A.COMMENTS
FROM SMART_STUDY_INFO AS A
WHERE A.WR_DISPLAY_DT<=#06/27/1997# AND A.WC_DISPLAY_DT <=#08/07/1998#;

Please try to find what is the error .

Thanks

[Datagopherdan]

Are you sure that they are both date data types? Also, I would recommend using "Between" instead of <= e.g.

A.WR_DISPLAY_DT Between #06/27/1997# AND A.WC_DISPLAY_DT <=#08/07/1998#;

hi all,
In one table there is two column for date like start and end date.I wanted to find all the record between start and end date based on the condition.I have written one query but it not working.Below is my query



Please try to find what is the error .

Thanks

[NTC]

you state a Start date and an End date ; but your sql statement is:
WHERE A.WR_DISPLAY_DT<=#06/27/1997# AND A.WC_DISPLAY_DT <=#08/07/1998#;

those are both <

the Start Date would be >= while the End date would be <=