Time zone issue

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.

  Discussion posts and replies are publicly visible

Parents Reply Children