Hi all, please assist I am going crazy..
What would be wrong with this:
strCondition = "Format([tblOrderLineTrack_main].[dtAllocation],'dd/MM/yyyy') BETWEEN Format(#06/02/2015#,'dd/MM/yyyy') AND Format(#07/03/2015#,'dd/MM/yyyy')"
DoCmd.OpenReport strDocName, acViewPreview, , strCondition, acWindowNormal
The report is failing to filter, is there anything wrong with the BETWEEN function syntax here? The report is showing up all records including those that are outside the specified dates! Please assist.
Thank you