RESOLVED: date format for RecordSelectionFormula

[stingrae]

I am trying to pass in two dates to my Crystal Report (from VB.Net) and am getting frustrated.

if i run the report with no value in the RecordSelectionFormula parameter, the report works perfectly (showing all data).

By when i add the following lines of code:

        rpt.DataDefinition.RecordSelectionFormula = "{tbl_ClassMaster.cms_Start} >= #" & Format(dtpDisplay.Value, "dd-MMM-yyyy") & " 0:00:00# " & " And " & _
                                                    "{tbl_ClassMaster.cms_Start} <= #" & Format(dtpDisplay.Value, "dd-MMM-yyyy") & " 23:59:59# "

I get no data.

In the past, i've always converted dates to the form of #01-sep-2003 16:47:00# because i know that the backend will then convert it to whatever format it likes. if i were to use #03/09/2003# then i can either get data from march or september, depending upon which part of the world my user is in.

any help .....????

cheers.

[stingrae]

1 Hour later and this works:

        rpt.DataDefinition.RecordSelectionFormula = "({tbl_ClassMaster.cms_Start} >= #" & Format(dtpDisplay.Value, "dd-MMMM-yyyy") & " 0:00:00#) And " & _
                                                    "({tbl_ClassMaster.cms_Start} <= #" & Format(dtpDisplay.Value, "dd-MMMM-yyyy") & " 23:59:59#) "

unbelievable!