Print Page | Close Window

Print date with different time zone

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1234
Printed Date: 03 May 2024 at 6:53am


Topic: Print date with different time zone
Posted By: teddybear
Subject: Print date with different time zone
Date Posted: 27 Aug 2007 at 10:34pm

Hi,

I have this question and hope someone can advise.
 
I am designing reports in Japan and scheduled it to run in a server in US. In the report, I have a special field "Print date" at the footer of the report.
 
When the report is printed, the date printed is refering to the US date.
 
In this case, how can I make sure that the date printed is refering to Japan time zone.
 
Thank inn advance.


Replies:
Posted By: BrianBischof
Date Posted: 28 Aug 2007 at 1:35am
I cover this on page 564 of my CR Encyclopedia book. You have to use the ShiftDateTime() function. However, the time zone strings can be a bit complex so you should look this up in the help file for the details.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>


Print Page | Close Window