[RESOLVED] CR 10.2 Error Message???

[blakemckenna]

I'm not sure exactly how to process a SelectionFormula where a value is evaulating a DateTime variable. I have the following statement:

{tblRequest.requestDate} IN '7/1/2007 7:02:55 AM' TO '7/25/2007 7:02:55 AM'


I keep getting the Error Message "Error in Formula". Please see attachment for entire message.

Thanks,

[brucevde]

I doubt this is your actual code. Does your report contain parameters or are setting the formula in VB? Regardless, convert the strings to dates.

Crystal has several functions to do just that. CDate might work.

{tblRequest.requestDate} IN CDate('7/1/2007 7:02:55 AM') TO CDate('7/25/2007 7:02:55 AM')

[blakemckenna]

Bruce,

That was it. Thanks bro!