I am currently using Crystal Reports Developer (10.0.0.533). I am seeing an issue with the way that it handles dates.
I have a stored procedure that returns a DateTime value from my database along with some other fields. I take that DateTime and display it as a string.
When I set the DateTime value to a dateTimeVar and display it as text like so...
local dateTimeVar myDate = {spGetMyDate.SomeDate};
ToText(myDate, "MMM yy");
When I display this as a string, the date is not at all what I expect. The year comes out to -471.
However, if I use the call to the stored procedure directly in the ToText like so...
ToText({spGetMyDate.SomeDate}, "MMM yy");
... it returns the proper date with the correct year.
Does anyone know if earlier versions of Crystal Reports 10 have problems with DateTime values when assigning them off to a local variable?