Skip to Content
avatar image
Former Member

Shift Date Time conversion from central time to eastern.

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 13, 2017 at 07:11 PM

    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

    Add comment
    10|10000 characters needed 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")

  • Oct 13, 2017 at 07:17 PM

    The picture may explain it better

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 18, 2017 at 01:58 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded