A period Of date

[kbsudhir]

Hi All,

I have two fields named "StartDate" & "EndDate", Now I want to create a query to find if the date entered falls between/On StartDate & EndDate in any of entries in the table.

How to do this...??

:dunno :dunno

Thanks
Sudhir

[Mavyak]

SELECT IIF(<DATE_ENTERED> Between StartDate And EndDate, "True", "False")

[kbsudhir]

Below is the query which I wrote but I am getting syntax error,
Please let me know where I am going wrong.

SELECT LeavePlanner.Name, LeavePlanner.LeavesStartDate, LeavePlanner.LeavesEndDate
FROM LeavePlanner IF(#10/30/2008# Between StartDate And EndDate, "True", "False")
GROUP BY LeavePlanner.Name, LeavePlanner.LeavesStartDate, LeavePlanner.LeavesEndDate;

[Mavyak]

SELECT LeavePlanner.Name, LeavePlanner.LeavesStartDate, LeavePlanner.LeavesEndDate
FROM LeavePlanner
WHERE #10/30/2008# Between StartDate And EndDate
GROUP BY LeavePlanner.Name, LeavePlanner.LeavesStartDate, LeavePlanner.LeavesEndDate;

[kbsudhir]

Thanks Mavyak, I made mess of the things earlier.