[RESOLVED] Error 20515 A date is required here.

Attachment 160495

I'm getting this error when generating report.

The error falls in this line.

Code:

---

            .SelectionFormula = "{View_MasterInfo.EmployeeType} <> 'RANK & FILE' and {View_MasterInfo.DateHired} <= '" & DTPicker1.Value & "'"

---

What do you think I'm missing?

The quotes around the date don't seem paired...

<= '7/23/2018

Which database (Access, SQL, etc) are you using? Some may require a symbol surrounding the data, i.e., #date#

Edited: Is this Crystal Reports? There is a another part of the forums dedicated to that.
http://www.vbforums.com/forumdisplay.php?33-Reporting

Does CR require a Date() function, i.e., "... <= Date(" & Format(dtPicker1.Value, "yyyy,mm,dd") & ")"

Thank you guys for your help.

I solved the problem using Lavolpe solution.

:)