If the timezone of NOW() is changed, it is required to change the timezone of Spreadsheet. Unfortunately, in the current stage, NOW() which is the built-in function has no options for changing the timezone. If my understanding is correct, how about this answer? Issue and Workaround: You want to achieve this using Google Apps Script.You want to put the time converted to the different timezone to the Spreadsheet as a text.You want to use the different timezone without changing the local timezone of Spreadsheet.I could change the time in the spreadsheet settings, but I need it saved in local time. I use a trigger every 1 minute to update the time in the spreadsheet, I would like to know what I could do to solve this problem. Spreadsheet.getCurrentCell().setFormula('=text(now("UK"),"yyyy/mm/dd hh:mm")') īut failed to return. So that this no longer happens, I would like to know how I could add the England time zone within the NOW () function. Spreadsheet.getCurrentCell().setFormula('=text(now()+"5:00","yyyy/mm/dd hh:mm")') Īnd now many hours later I realized the failure and needed to switch to: I had a big problem today because Google's times have changed and my data has been filtered the wrong way. What happens is that I have a whole spreadsheet ready to filter data in the England time zone. I live in Brazil (UTC offset of - 3:00) and here we have something called daylight saving time, where at some times of the year the clocks are advanced by 1 hour.
0 Comments
Leave a Reply. |