Wrong Format of Date when Displayed

Question

I have a google sheet with a column that has a data that looks like this.

8/31/2017 11:45:41

and that format is Date Time

now when Im using the google code .getValues and display it in Logger.log

this is the output

Fri Sep 01 02:45:41 GMT+08:00 2017

My Question is How can I get the value as it is? I dont want to get it as time stamp I want the format like 8/31/2017 11:45:41 or M/D/YYYY HH:MM:SS really same as what it displays in sheet.

here is my code.

//Convert Timestamp to M/D/YYYY HH:mm:ss
function ConvertToYMDHS(inputFormat){
  var userTimeZone = CalendarApp.getDefaultCalendar().getTimeZone();
  return inputFormat ? Utilities.formatDate(inputFormat, "GMT-8:00", "M/d/yyyy HH:mm:ss") : "";
}

ConvertToYMDHS("Cell of the Column that has a Date");

Possible duplicate of [How to format a JavaScript date](https://stackoverflow.com/questions/3552461/how-to-format-a-javascript-date) — JSON Derulo, Sep 06 '17 at 05:50
@D.Simon That question doesn't tell, how to use `Utilities.formatDate` method. — Teemu, Sep 06 '17 at 05:53
Thats true so it has nothing to do with the possible duplicate youve tag to my question — Nardong Bagsik, Sep 06 '17 at 05:56

score 2 · Accepted Answer · answered Sep 06 '17 at 06:02

2

How about a modification as follows?

From :

var val = SpreadsheetApp.getActiveSheet().getRange("a1").getValue();
Logger.log(val)

>>> Thu Aug 31 11:45:41 GMT+09:00 2017

To :

var val = SpreadsheetApp.getActiveSheet().getRange("a1").getDisplayValue();
Logger.log(val)

>>> 08/31/2017 11:45:41

Of course, you can also use getDisplayValues() for retrieving values from several cells as 2 dimensiolnal array.

The detail information of getDisplayValue() is here.
The detail information of getDisplayValues() is here.

If I misunderstand your question, I'm sorry.

answered Sep 06 '17 at 06:02

Tanaike

105,090
8
51
83

Wow! Thats simple yet so awesome – Nardong Bagsik Sep 06 '17 at 06:04
Wow your soooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo awesome love you men <3 – Nardong Bagsik Sep 06 '17 at 06:07
@paul pagente Thank you. ``getDisplayValue()`` can retrieve the value displayed in the cell. – Tanaike Sep 06 '17 at 06:07
Yes TYSM for big help – Nardong Bagsik Sep 06 '17 at 06:08
Hi Sir TYSM again. #MyHero – Nardong Bagsik Sep 07 '17 at 09:19
@paul pagente oh, again? – Tanaike Sep 07 '17 at 22:06
No Problem Sir. I just cant move on from this topic. You really did a great help. TYSM from the bottom of my left venticel(Heart) hahaha – Nardong Bagsik Sep 07 '17 at 23:55
@paul pagente I'm glad I could be helpful for you. – Tanaike Sep 07 '17 at 23:57
Looking forward to have a more conversation with you because, I checked your profile and I noticed we have in common and that is Google Spcript especially in Google Sheet. – Nardong Bagsik Sep 08 '17 at 00:20
@paul pagente Thank you. – Tanaike Sep 08 '17 at 00:25
Do you have an HO Account? – Nardong Bagsik Sep 08 '17 at 00:32
@paul pagente Sorry. I don't know about it. – Tanaike Sep 08 '17 at 00:37
ahh i see. its ok, looking forward to see you here around again. TY – Nardong Bagsik Sep 08 '17 at 00:39

Wrong Format of Date when Displayed

1 Answers1

From :

To :