Skip to Content
0
Jan 19, 2021 at 07:53 PM

Date Off by One Day

159 Views Last edit Jan 19, 2021 at 08:11 PM 2 rev

Hello!

I'm having issues with dates appearing one day early in *some* instances.

When building a report in Crystal Reports 11.5.0.313, all of the dates passed into Crystal appear correct when previewing said report. Once the report is saved and pushed to our servers, the majority of the time the dates appear correct but in some instances, the dates are one day off.

For instance, if I create a report based on the date "07/10/1980", the report PDF shows the correct date. However, if I create a report based on the date "03/15/1971", when the PDF loads, it shows the date as "03/14/1971". The date field is does print correctly more often than not. I have verified the actual date in data is indeed correct and doesn't show incorrectly until the report is generated. In an attempt to resolve this issue, I've tried altering the date field in a formula as well as adding 10 hours to the date. I've had no luck in finding a resolution

After searching, I've found minimal issues in recent years, which makes me wonder if it's version related. I can reproduce this behavior on a test server that's running:

Crystal Reports Basic Runtime for Visual Studio 2008 - Version 10.5.1.0

Crystal Reports Basic Runtime for Visual Studio 2008 (x64) - Version 10.5.0.0

SAP Crystal Reports runtime engine for .NET Framework (32-bit) - Version 13.0.5.891

SAP Crystal Reports runtime engine for .NET Framework (64-bit) - Version 13.0.5.891

Any advice is greatly appreciated.