Need to change time zone on data

[Rudy]

I am importing data based on a calling center. The data
is represented in CST (Central Standard Time). Is there a
way I can have the data represented in another time zone?

I appreciate your response.

 

[fredg]

I am importing data based on a calling center. The data
is represented in CST (Central Standard Time). Is there a
way I can have the data represented in another time zone?

I appreciate your response.

Well, Pacific Standard Time is 2 hours earlier than Central Standard
Time, so:
PacificTime = DateAdd("h",-2,[Central StandardTime])

Going eastward, you would add an hour for each time zone.

NOTE: You do need to know whether the area in the Pacific Time Zone
changes (or doesn't change) to Daylight Savings time when the Central
Time area does. Some States, Arizona comes to mind, do not change, so
if the area were to be in Arizona you would need to use
DateAdd("h",-1,[Central Daylight Time])

 

[Rudy]

Fred,

Thanks a bunch, I'll give it a try!

-----Original Message-----

I am importing data based on a calling center. The data
is represented in CST (Central Standard Time). Is there a
way I can have the data represented in another time zone?

I appreciate your response.

Well, Pacific Standard Time is 2 hours earlier than Central Standard
Time, so:
PacificTime = DateAdd("h",-2,[Central StandardTime])

Going eastward, you would add an hour for each time zone.

NOTE: You do need to know whether the area in the Pacific Time Zone
changes (or doesn't change) to Daylight Savings time when the Central
Time area does. Some States, Arizona comes to mind, do not change, so
if the area were to be in Arizona you would need to use
DateAdd("h",-1,[Central Daylight Time])


--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

 

[fredg]

Fred,

Thanks a bunch, I'll give it a try!

-----Original Message-----

I am importing data based on a calling center. The data
is represented in CST (Central Standard Time). Is there a
way I can have the data represented in another time zone?

I appreciate your response.

Well, Pacific Standard Time is 2 hours earlier than Central Standard
Time, so:
PacificTime = DateAdd("h",-2,[Central StandardTime])

Going eastward, you would add an hour for each time zone.

NOTE: You do need to know whether the area in the Pacific Time Zone
changes (or doesn't change) to Daylight Savings time when the Central
Time area does. Some States, Arizona comes to mind, do not change, so
if the area were to be in Arizona you would need to use
DateAdd("h",-1,[Central Daylight Time])


--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

Oops!!!
I just remembered, Arizona is Mountain Time, not Pacific Time.