This has solved the problem - Thankyou.
It was my mistake - I am using the masked edit control in VB to enter a time. This does not keep the colons in the string hence 23:00:00 becomes 230000 when passed into Crystal.
Thankyou once again.
Hi All.
This is the code I am using to pass values from VB into a parameter field in Crystal Reports
Report.ParameterFields.Item(1).AddCurrentValue = CDate("27/05/02")
The CDate formatting works but how do you pass a time into Crystal, for example......
Report.ParameterFields.Item(1).AddCurrentValue = "23:00:00"
This results in a Type Mismatch error. What datatype would I need to use??
Help!!!
![]()


Reply With Quote