-
I need to pass a datetime field to crystal reports as a parameter. I used thecdate function to convert a string datetime value to a date field in VB. But, as the vb datatype is date and cr datatype is datetime.I am getting an error. How do I solve it
-
You could use something like that:
Dim Param$
Dim dates1 As String
dates1 = Format(meDate1, "YYYY, MM, DD")
'where meDate1 is the name of MaskEditBox where you enter your date
Param = "{YourQuery.Date1} in Date (" & dates1 & ") to Date (" & dates1 & ")"
'YourQuery -is the name of your table/query
'Date1 -is the field is your table with date
Call View_Report("Your_Report.rpt", True, Param)
'code for View_report I posted couple days earlier
-
well..
I tried searching your post but i couldnt find.. can u send me the thread link
Thanks in advance:)