Incorrect time while copy pasting a date time value using google apps script

Asked Nov 18 '17 at 11:55

Active Nov 18 '17 at 12:25

Viewed 288 times

I am getting a time value from one sheet (A) and putting in another sheet (B), some 32 minutes are getting added to the time value in sheet (B). Here is the code:

function pushRow() {
   var ss = SpreadsheetApp.getActive();
   var s1 = ss.getSheetByName ("Sheet1");
   var s2 = ss.getSheetByName("Sheet2");
   var data = s1.getRange("A2:C2").getValues();
   s2.appendRow(data[0]);

}

Here is the screenshot of both the sheets:

Sheet (A):

enter image description here

Sheet (B):

enter image description here

edited Nov 18 '17 at 12:25

mplungjan

169,008
28
173
236

asked Nov 18 '17 at 11:55

Ajay Tyouharia

`Indian Standard Time is UTC+05:30).` - sounds like you get the 30 minutes plus the age of the time stamp – mplungjan Nov 18 '17 at 12:27
In the script editor, click "File" -> "Project Properties" and look at the time zone setting. Then in the spreadsheet, click "File" -> "Spreadsheet Settings" and see if the time zone is different. – Alan Wells Nov 18 '17 at 15:42
I wonder if it has something to do with the validation in the time column in Sheet(A) – Cooper Nov 18 '17 at 18:21
check if `getDisplayValues` returns the correct value – Ritesh Nair Nov 18 '17 at 18:41
@SandyGood: Time zone is same at both in script editor as well as in Spreadsheet. – Ajay Tyouharia Nov 20 '17 at 08:31
1

@Ritz: getDisplayValues works perfectly. Thanks a Ton! Although it's still weird why getValues is getting wrong time. – Ajay Tyouharia Nov 20 '17 at 08:39

Incorrect time while copy pasting a date time value using google apps script

0 Answers0