Hello fellow Bubblers,
Right now I’m continuing my work on an app I’ve been trying to use for a while now. The trouble comes when I use a formatting option someone posted in a help topic a while ago:
=query(split(“MYDATE”," "),“select Col5”)
Where you see MYDATE is where I perform the zapier link, which will return:
=query(split(“Tue, 30 May 2017 13:55:26 GMT”," "),“select Col5”)
The problem is that I am not in GMT, I am in EST, so when the zap is pushed to google sheets it formats to GMT, but the time that is shows is not correct for my time. What can I do to correct this?