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!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Converting time from Eastern to Central

Status
Not open for further replies.
jaburke

jaburke

Programmer
May 20, 2002
156
US
Hi,
I am trying to convert the time from Eastern to Central. I have a formula that ALMOST works. Does anybody have a quick solution?

Much thanks!
 
Sort by date Sort by votes
DateAdd("h", 1, {your.datetime}) will add an hour. 2 would add 2 hours, -3 subtract 3 etc.

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

POrlowski
  • Locked
  • Question
Calculating Sick Time
Replies
7
Views
428
POrlowski
POrlowski
socalvelo
  • Locked
  • Question
Extract Phone Numbers from Text Field
Replies
0
Views
284
socalvelo
socalvelo
D
  • Locked
  • Question
Running total from a subreport only showing last value
Replies
4
Views
623
doodledump
D
mmck1964
  • Locked
  • Question
Using "OR" to select data
Replies
4
Views
505
mmck1964
mmck1964
jchewsmith
  • Locked
  • Question
Report filter to run report yeartodate through yesterday
Replies
0
Views
319
jchewsmith
jchewsmith

Part and Inventory Search

Sponsor

Back
Top