Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Crystal Reports X and DateTime Post Reply Post New Topic
Author Message
kwsanders
Newbie
Newbie


Joined: 10 Jul 2007
Online Status: Offline
Posts: 5
Quote kwsanders Replybullet Topic: Crystal Reports X and DateTime
    Posted: 27 Jul 2007 at 7:53am
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?

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.