Shift Date Time conversion from central time to eastern.

[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.

[vitaly_izmaylov]

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.

[vitaly_izmaylov]

The picture may explain it better

[vitaly_izmaylov]

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

[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")