var tanggalnya = new Date();
var waktuEdit = Utilities.formatDate(tanggalnya, "GMT+7", "dd/MM/YY");
var timeZone = Session.getScriptTimeZone();
var tanggalHariIni = Utilities.formatDate(new Date(), timeZone, "dd/MM/yyyy");
var tanggalDgJam = Utilities.formatDate(new Date(), timeZone, "dd/MM/yyyy HH:mm:ss");
const today = new Date();
const yesterday = new Date(today);
yesterday.setDate(yesterday.getDate() - 1);
var tanggalHariIni = Utilities.formatDate(today, "GMT+7", "dd MM yyyy");
var tanggalKemarin = Utilities.formatDate(yesterday, "GMT+7", "dd MM yyyy");