pasin
November 14th, 2008, 09:04 AM
I have created a parameter named datapare in cr of type date. When I try to pass the date from vb to cr happens a strange thing.
crystalReport1.ParameterFields(1) = "datapare; date(" & Format(DTPicker1.Year, "yyyy") & "," & Format(DTPicker1.Month, "mm") & "," & Format(DTPicker1.Day, "dd") & "); true" Format(DTPicker1.Month, "mm") & "," & Format(DTPicker1.Day, "dd") & "); true"
Debug.Print CrystalReport1.ParameterFields(1)
The output of the last line is:
datapare; date(1905,01,30); true
Even if I enter today's date
crystalReport1.ParameterFields(1) = "datapare; date(" & Format(DTPicker1.Year, "yyyy") & "," & Format(DTPicker1.Month, "mm") & "," & Format(DTPicker1.Day, "dd") & "); true" Format(DTPicker1.Month, "mm") & "," & Format(DTPicker1.Day, "dd") & "); true"
Debug.Print CrystalReport1.ParameterFields(1)
The output of the last line is:
datapare; date(1905,01,30); true
Even if I enter today's date