gmt(now) is not working

All datetimes in Appian are in GMT, so when you save a pv of type datetime with a value of now(), it will be persisted to DB in GMT.

somehow my time is saved as is in EST in Database  without converting to GMT . 

 

As a short term fix,  i accomplished my time by adding 4 hours using datetime since all of our users are in EST 

 a!gridTextColumn(label: "Added On", field: "createdDtm", data:datetext(datetime(year(index(local!docDataSubset.data,"createdDtm")), month(index(local!docDataSubset.data,"createdDtm")), day(index(local!docDataSubset.data,"createdDtm")), (hour(index(local!docDataSubset.data,"createdDtm"))+4), minute(index(local!docDataSubset.data,"createdDtm")), second(index(local!docDataSubset.data,"createdDtm"))),"MM/dd/yyyy hh:mm:ss")),

somehow my time is saved as is in EST in Database  without converting to GMT . 

 

As a short term fix,  i accomplished my time by adding 4 hours using datetime since all of our users are in EST 

 a!gridTextColumn(label: "Added On", field: "createdDtm", data:datetext(datetime(year(index(local!docDataSubset.data,"createdDtm")), month(index(local!docDataSubset.data,"createdDtm")), day(index(local!docDataSubset.data,"createdDtm")), (hour(index(local!docDataSubset.data,"createdDtm"))+4), minute(index(local!docDataSubset.data,"createdDtm")), second(index(local!docDataSubset.data,"createdDtm"))),"MM/dd/yyyy hh:mm:ss")),

User timezone settings do not matter. Are you sure that data in DB is in EST (have you checked the table contents, or in the interface)? If timestamps are in EST that could mean bad app server settings and will cause issues - you need to address this instead of working around it.