Open Report w DateAdd function

[libraccess]

Private Sub btnCertsExp_Click()


DoCmd.OpenReport "rptCerts", acViewPreview, , "[CertDateExp] < " & DateAdd("m", 2, Date)
End Sub

so this opens my report but with no results - because I dont know how to get the Format right

in the reports Filter Property I have [CertDateExp] < 21/04/2013 and of course if I change it to

[CertDateExp] < #21/04/2013# all works well. I just need to know how to do this in the procedure

Thanks everyone

[pbaldy]

This should help:

http://www.baldyweb.com/wherecondition.htm

[pbaldy]

With the non-US date format, you'll also have to watch out for:

http://allenbrowne.com/ser-36.html

[libraccess]

Whoah that was quick, and then I'd just finished rewriting the procedure and trying out and you posted again, it worked in down date format but I'll read up, I have made extensive use of the Allen Browne code for between two dates and in fact I spent a bit of time looking at that to try solving this.