I have a script that creates a prefilled form link for users to edit. There is a datetime question in that form that, no matter what I do, always seems to assume I’m in the UTC time zone instead of New York/UTC-4, as it’s adding 4 hours to the prefilled datetime object. e.g., when the prefilled form is accessed, the datetime question is always 4 hours later than the actual input being supplied.

I’ve doublechecked the time zone settings for the Sheet as well as for the script, and they’re both set correctly to US Eastern/New York. Is there any way to correct this without manually subtracting time from the datetime object before submitting the form answer?

  //Populate Timestamp
  formItem = formItems[0].asDateTimeItem();
  response = formItem.createResponse(new Date(data[1]));  //data[1] is a datetime string in UTC-4
  formResponse.withItemResponse(response);