Time Format - **RESOLVED**

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!!!
:mad:

I'm pretty sure you can still use the CDate function, eg

VB Code:

Report.ParameterFields.Item(1).AddCurrentValue = CDate("23:00:00")

After all, dates & times are the same datatype, ie DateTime.