Utilities.formatDate()

[Fransiskus Xaverius Airell Valerio Satrio Wibowo C0080904]

Hello, I want to ask if my code is well used when extracting date into string.

  var sheet = SpreadsheetApp.getActiveSheet();

  var n_column = sheet.getLastColumn();

  var n_row = sheet.getLastRow();

  var data_range = sheet.getRange(2, 1, n_row - 1, n_column);

  var data_base = data_range.getValues();

  var date = data_base[2][5];

  date = Utilities.formatDate(date, "GMT", "EEEE, d MMMM YYYY");

  Logger.log(date);

I use this code to try, but when I debug it, the date is not correct. It always show 1 days before the actual date in spreadsheet. Can you help me to find another solution? I'm confused why it shows 1 days before. Thank you.

[Google Ads API Forum Advisor Prod]

Hello,

This issue doesn't appear to be Google Ads API related. Since you are having issues with Apps Script, you can get support by following this link.

Regards,
Anthony

Anthony Google Ads API Team

ref:_00D1U1174p._5004Q2EmiP9:ref