I have the spreadsheet and GS App location set to Australia but continue to get UTC timestamps for updates - have tried altering these lines "CST" to "GMT+10" without a result - any suggestions?
var date_now = Utilities.formatDate(new Date(), "CST", "yyyy/MM/dd"); // gets the current date
var time_now = Utilities.formatDate(new Date(), "CST", "hh:mm:ss a"); // gets the current time
BTW - great project :)
I have the spreadsheet and GS App location set to Australia but continue to get UTC timestamps for updates - have tried altering these lines "CST" to "GMT+10" without a result - any suggestions? var date_now = Utilities.formatDate(new Date(), "CST", "yyyy/MM/dd"); // gets the current date var time_now = Utilities.formatDate(new Date(), "CST", "hh:mm:ss a"); // gets the current time BTW - great project :)