RESOLVED: date format for RecordSelectionFormula
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:
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 .....???? :confused:
cheers.