Help with query with date parameters

[eacollie]

I have a form based on this query:

SELECT qryReservationsMC.*, IIf([AddedToOutlook]=True,"*","|") AS Status
FROM qryReservationsMC
WHERE (((qryReservationsMC.EndDate)>=Format([Forms]![frmCalendar]![txtDate],"Short Date")) AND ((qryReservationsMC.StartDate)<=Format([Forms]![frmCalendar]![txtDate],"Short Date")));

it gives me an error "the expression is typed incorrectly or is too complicated..." I think I need "#" for the dates.

Any help?

 

[Trevor G]

Have you formatted the Textbox on the form to use dates format otherwise it looks to indicate them as text.