1 Reply Latest reply on Jun 14, 2018 9:55 PM by pavan kumar

    Alert - Time Zone Issue

    Kary K

      Hi All,

       

      I'm using an alert on date using the following calculation using the sheet displayed below which shows axis.

       

      IF (max(date))=TODAY() then 1

      ELSE 0

      END

       

      I'm able to get the alert to my email but I noticed that I'm getting the alert at 12:00 AM GMT. I'm looking for the alert at EDT 6 am.

       

      Could someone please let me know the solution for this?

       

      Thanks,

      Kary.

        • 1. Re: Alert - Time Zone Issue
          pavan kumar

          Hi,

          Try to add the time to your calcuation so that it will account for EDT.

          some thing like below

          IF (max(date))=TODAY() and dateadd('hour',1,'Today()= 6 then 1

          ELSE 0

          END     

          and then set the alert .

          Basically if max date is equal to  today and extract time from today is equal to EDT 6 AM then 1 else 0 end

          Regards,

          Pavan