vithu
Reputation: 1
Google sheets timezone
so, I have this google sheets from where, I need to generate some PDF, it's working fine, except the date. if I have selected the date as 29/12/2021 in my sheet, it appears as 28/12/2021 in the generated PDF. I don't what went wrong, I have tried changing the locale and time zone. but nothing came out as well. what's exactly the problem? and I wanted to know that, is there any way I can change this using apps-script?
Upvotes: 0
Views: 72
Answers (1)
Mike Steelson
Reputation: 15318
The best and simpliest way is to use .getDisplayValue() instead of .getValue()
Upvotes: 1
Related Questions
- Google Apps Script Trigger Timezone Will Not Change
- Google app script reading different timezones from Spreadsheet
- Dealing with time zones in Apps Script when importing data into Google Sheets
- Google Script Running Off Incorrect Timezone
- Time zones in Google Apps Script
- Simple TimeZone Question for Google Script
- how to change timezone in googlesheet?
- Google Apps Script: Time Driven Triggers timezone issue
- Problem dealing with date/time and timezone
- Google Scripts Triggers - wrong timezone