Display Timezone
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=22927
Printed Date: 09 May 2024 at 8:12pm
Topic: Display Timezone
Posted By: nicmcd77
Subject: Display Timezone
Date Posted: 23 Feb 2021 at 7:54am
Does anyone know how to display the timezone? I used Print Time Zone but it displays with way more information than I need. I just want "EST" or "CST". Any ideas? Worst case can I just split out everything after the first comma if I use Print Time Zone?
The print time zone displays CST as:
Central Standard Time,360,Central Daylight Time,-60;3.2.0/02:00,11.1.0/02:00
which is way too much info
|
Replies:
Posted By: Valert16
Date Posted: 28 Feb 2021 at 12:09am
Never had used PrintTimeZone, and not sure about how it works, but maybe a formula can produce the result you need.
Create a formula like this:
If PrintTimeZone like "Central Standard Time*" Then
"CST"
Else If PrintTimeZone like "Eastern Standard Time*" Then
"EST"
Else
""
You could add more sentences If.. Then if there are more time zones.
Use the formula instead of the PrintTimeZone field.
|
|