I am saving a created date of a document as shown below . My requirement is to store as GMT . show how when i go to database it is still storing as EST .
This is my Write to database node
what could be the reason ?
Discussion posts and replies are publicly visible
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")),