Skip to main content
J
jaganc880
Participating Frequently
March 4, 2021
Question

Time zone issue

  • March 4, 2021
  • 3 replies
  • 0 views

My DB is in GMT & Appian environment is in EST, when we take action in night time(after 7pm EST) date is showing always a future date so we tried to convert that date into EST by using this function text(gmt(local(now(),"EST")),"m/d/yyyy") its giving correct date, but in day time when we tried this its giving past date can anyone suggest what is the solution.

Thank in advance.

3 replies

stefanhelzle0001
stefanhelzle0001
Brainy
March 5, 2021

If this is a process started by a timer, make sure that the timezone of the process is correct. All date&time calculations in a process happen in the process timezone which is either the timezone of the user which started the process, or the user which deployed the model in case of a scheduled process.

J
jaganc880Author
Participating Frequently
March 7, 2021

Thanks for your replay, my process& initiators are in EST time zone only but we are still facing the same problem ( future date)  when ever we retrieve the date from the DB even we used this function  text(gmt(local(now(),"EST")),"m/d/yyyy")

Thanks

stefanhelzle0001
stefanhelzle0001
Brainy
March 7, 2021

Please elaborate on what you want to achieve. We need more details to be able to help.

Terms & ConditionsAccessibility statement