DateTime Issue

[R00k1e]

Hello,

I have a View created in SQL Server that has a column with date information as a varchar. I did a Cast to that column to make it a DateTime. So in Crystal, that field displays as a DateTime but when I go to Select Expert and try to make it equal to my "DateTime" type parameter, it won't pick up. Is there something I have to do differently on the SQL end to make this work?

Any help would be greatly appreciated.

 

[IanWaterman]

Go to field explorer and open database, right click any field and check show field type.

Does Crystal see it as datetime?

Ian

 

[R00k1e]

Hi Ian,

Yes, Crystal does show the field as a DateTime.

BTW I am using Crystal 9.

 

[IanWaterman]

Ok don't use the select expert wizard.

Go into the select formula and manually enter field and parameter as you would with a normal formula.

That should allow you to use it.

Ian

 

[lbass]

I think you might have to add datetime formatting in the cast function. I've found that to be the case when converting dates in commands. Place both the parameter and the datetime field on the report canvas and see how they display.

-LB

 

[crystalkiwibruce]

The Select Expert thinks a date parameter and a date time field are different types.

You will need to use the Record Selection Formula.