Date format issue, google apps script

Question

I have a column contain a date in "Sep -13" format.

When I access it from code, it gives integer value. How can I get a date object?

If I use "dd/mm/yyyy" format in sheet, it gives me date object.

function check()
{
  var source = SpreadsheetApp.openById('sheet id');
  var sourcesheet = source.getSheetByName('sheet name');   
  var tt = sourcesheet.getRange('F700').getValue();
   debugger;
}

Result:

I tried replicating your issue. If I click the column heading, and make the entire column a date format, I get a date in the code. If I format the entire column as a number, I get a number. So, I was not able to duplicate your issue. — Alan Wells
– Alan Wells, Commented Apr 8, 2016 at 20:23

iJay · Accepted Answer · 2016-04-12 06:03:01Z

1

That cells original value might be an integer. That could be happen if you copy and paste values only for a date. so .getValue() will give you that number.

You can use that number to create a date object. JavaScript dates can be constructed by passing milliseconds

//base date 01/01/1970 integer value :25569 
//excelDate your date in integer

var myDate = new Date((excelDate - 25569)*86400*1000);

edited Apr 12, 2016 at 6:03

answered Apr 12, 2016 at 5:40

iJay

4,3035 gold badges37 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Date format issue, google apps script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related