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
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.
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
Please elaborate on what you want to achieve. We need more details to be able to help.