Rep.RecordSelectionFormula returns no one record.WHY?

[vlad2]

I Need to get all customers within DateRange
it's vb app,i use DTPicker to get the dates.

Here is code:

mobjReport.RecordSelectionFormula = "{ERCHistory.CreateDate} in Date(" & DateFrom & &quot to Date(" & DateTo & &quot"

What's wrong with that?
What's really interesting that.. this code works for some reports, but it does not work for two other reports.If I run the report without RecordSelectionFormula then report gets popuilated with records.But if i use the RecordSelectionFormula than report is displayed with out records.

What may cause this problem?
THANKS FOR ANY Help.

 

[vlad2]

I found the problem!

I sended the dates from another form. and i did not format the date values.

'mm/dd/yyyy'- incorrect

"yyyy,mm,dd" - correct

thanks you God