Skip to Content
0

Shift Date Time conversion from central time to eastern.

Oct 13, 2017 at 05:27 PM

51

avatar image
Former Member

Dear Experts,

I want to convert my date time value from central time to eastern.I know that Eastern Time is 1 hour ahead of Central Time.

I am using below formula to convert time

ShiftDateTime({Work_Orders.u_actual_change_start_date},"CST,480,CDT","EST,300,EDT")

Actual Value : 8/31/2017 11:00:00 PM ,

Expected value 9/01/2017 00:00:00 AM

But i am getting output : 9/01/2017 2:00:00 AM when using above formula.

Please suggest.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Vitaly Izmaylov
Oct 13, 2017 at 07:11 PM
0

In your formula 480 is a time difference in minutes between GMT and CST

and 300 is a difference between GMT and EST

With those values you told Crystal there are 180 minutes difference between CST and EST.

I would suggest to change 480 to 360

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks for your answer, Its works fine for me.

I am generating a report for last month, it will work fine for Sep, Oct & Nov month, what will happen if I generate a report on Dec Month, Because, from 5th Nov 2017, Daylight savings time will turn backward 1 hour.

Please suggest how to handle this dynamically by using shift date time function.

ShiftDateTime({Work_Orders.u_actual_change_start_date},"CST,360,CDT","EST,300,EDT")

0
Vitaly Izmaylov
Oct 13, 2017 at 07:17 PM
0

The picture may explain it better


Share
10 |10000 characters needed characters left characters exceeded
Vitaly Izmaylov
Oct 18, 2017 at 01:58 PM
0

Look at the picture I attached, very last column. You need to specify in your formula when the Daylight shift is applicable. Do not need to say November 5th, but 1st (1), Sunday (0) of 11th month (11) at 2:00 am, etc. Exactly as in my example. It should work.

Share
10 |10000 characters needed characters left characters exceeded