I have the following criteria for a date field:
Between ([Forms]![frm_rptInspectionShiftYield_ByDateRange]![txtStartDate]) And ([Forms]![frm_rptInspectionShiftYield_ByDateRange]![txtEndDate])
my date field is formatted as: Expr1: CDate(Format([glassing_yield].[date_time],"mm/dd/yyyy"))
i want the query to pull records from 4 days before the start time, i tried using adding a -4
Between ([Forms]![frm_rptInspectionShiftYield_ByDateRange]![txtStartDate] - 4) And ([Forms]![frm_rptInspectionShiftYield_ByDateRange]![txtEndDate])
error is my expression is typed incorrectly, or it is too complex to be evaluated. how can i do this substraction?
furthermore, if i want to get the data for 3/28/12, i have to put 3/28/12 as a start date, and 3/29/12 as an end date. Is there a way to modify this to where i would enter 3/28/12 as the start AND end date?
thanks guys