Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Display Timezone Post Reply Post New Topic
Author Message
nicmcd77
Newbie
Newbie


Joined: 11 Oct 2016
Online Status: Offline
Posts: 1
Quote nicmcd77 Replybullet Topic: Display Timezone
    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
IP IP Logged
Valert16
Groupie
Groupie
Avatar

Joined: 21 Mar 2016
Location: Spain
Online Status: Offline
Posts: 57
Quote Valert16 Replybullet 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.

Edited by Valert16 - 01 Mar 2021 at 11:49pm
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.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.