Date format in HTML table

Question

I am having trouble changing the date format in my HTML table. I want it to display as "9/1/22" but I am getting "Thu Sep 01 2022 16:55:58 GMT-0400 (Eastern Daylight Time)"

Here is my code:

function sampleFunction() {
  var sh = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  range = sh.getRange("E1").getValues();
  var data = sh.getRange(range).getValues();
  //var htmltable =[];

  var TABLEFORMAT =
    'cellspacing="2" cellpadding="2" dir="ltr" border="1" style="width:100%;table-layout:fixed;font-size:10pt;font-family:arial,sans,sans-serif;border-collapse:collapse;border:1px solid #ccc;font-weight:normal;color:black;background-color:white;text-align:center;text-decoration:none;font-style:normal;';
  var htmltable = "<table " + TABLEFORMAT + ' ">';

  for (row = 0; row < data.length; row++) {
    htmltable += "<tr>";

    for (col = 0; col < data[row].length; col++) {
      if (data[row][col] === "" || 0) {
        htmltable += "<td>" + "None" + "</td>";
      } else if (row === 0) {
        htmltable += "<th>" + data[row][col] + "</th>";
      } else {
        htmltable += "<td>" + data[row][col] + "</td>";
      }
    }

    htmltable += "</tr>";
  }

  htmltable += "</table>";
  Logger.log(data);
  Logger.log(htmltable);
  MailApp.sendEmail(Session.getActiveUser().getEmail(), "Daily report", "", {
    htmlBody: htmltable,
  });
}

Any help would be greatly appreciated

See [*How do I format a date in JavaScript?*](https://stackoverflow.com/questions/3552461/how-do-i-format-a-date-in-javascript) — RobG, Sep 04 '22 at 09:23

Poku · Answer 1 · 2022-09-04T06:34:27.663

You can use the Date object to do that:

var today  = new Date();

console.log(today.toLocaleDateString("en-US")); // 9/4/2022

I don't know in which column your date data (you need to post the data in data object) but lets say the date is in the first column then you can do this:

  var data = [];
  var TABLEFORMAT =
  'cellspacing="2" cellpadding="2" dir="ltr" border="1" style="width:100%;table-layout:fixed;font-size:10pt;font-family:arial,sans,sans-serif;border-collapse:collapse;border:1px solid #ccc;font-weight:normal;color:black;background-color:white;text-align:center;text-decoration:none;font-style:normal;';  
  var htmltable = "<table " + TABLEFORMAT + ' ">';   
    
  for (var row = 0; row<data.length; row++){
    var formattedDate = new Date(data[row][0]).toLocaleDateString("en-US")
    
    htmltable += '<tr>';
    
    for (var col = 0 ;col<data[row].length; col++){
      if (data[row][col] === "" || 0) {htmltable += '<td>' + 'None' + '</td>';} 
      else {
        if (row === 0)  {
          htmltable += '<th>' + data[row][col] + '</th>';
        }        
        else if (col === 0) { htmltable += '<td>' + formattedDate + '</td>'}    
        else {
          htmltable += '<td>' + data[row][col] + '</td>';
        }
      }
    }
    
    htmltable += '</tr>';
  }

Note: I created local var data in example to make it compile. You should just use your own variables.

You shouldn't answer obvious duplicates, just link to the duplicate (or in this case, one of the many). If there is no suitable answer at the duplicate, answer there. — RobG, Sep 04 '22 at 09:24
Please link a duplicate post where the user ask how to format some data in an html table where the user is just looping over a data set. I helped the user solving his specific issue. I didn’t just link to some random how to format a date in JavaScript. — Poku, Sep 04 '22 at 11:15

Date format in HTML table

1 Answers1