Anyone have a good formula that will take a GMT datetime field and automatically convert it to EST? With the formula looking at each datetime entry to determine if its -4 or -5. I got one that can do one or the other I just need one that will change it from -5 hrs to -4 hrs on 03/09.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
GMT To EST datetime conversion help.
- Thread starter acentler
- Start date
Use a formula field to determine the proper difference:
Though since it has been made adjustable, this might be better done a parameter. Also one for changing it back, a date range.
![[yinyang]](/data/assets/smilies/yinyang.gif "[yinyang] [yinyang]")
Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10
Code:
if {your.date} < Date(2007, 03, 09) then 5 else 4- Status
Similar threads
- Locked
- Question
- Locked
- Question