Searching for a date with parameter query not working
Posted on 2011-10-20
Please can somebody help me. I have the following in a query
ExpiryDatemMnth: DateAdd("m",[NoMnthsTillExpiry],[DateofIssueProFormaCertificate]) which is working perfectly.
I now want to search within this query with a parameter query
Between [Enter Start Date here] And [Enter End Date here] so that I can produce an Certificate Expiry Date Report
And its not working as it doesnt seem to recognise the field as a date, I tried setting the properties to a date in the query but it still brings up a nil result as its not recognising the field. I think I am overthinking this. Help please.