Assigned
Status Update
No update yet.
Comments
jp...@google.com
Generated Metadata
- Summary: The Apps Script application is not working as expected. The first page works, but the second page does not. It is difficult to determine the root cause without additional information.
- Tags:
Additional resources:
https://developers.google.com/apps-script/guides/support/troubleshooting https://developers.google.com/apps-script/support https://stackoverflow.com/.../how-to-debug-or-view-logs-in-google-app-scr... https://stackoverflow.com/.../appscript-webapp-hyperlink-not-working-the-... https://stackoverflow.com/.../serve-separate-html-pages-google-apps-script-...
You can
bl...@google.com
Automated by Blunderbuss job workspace-devrel-public-issue-tracker-blunderbuss-autoassigner for config assign for component 191640.
mg...@teacherlearningnetwork.org.au
update
I created a new script to verify it was a persistent issue. This code also displayed incorrectly.
code
function onSpreadsheetUpdate() { var dcDate = new Date("February 23, 2025"); var fdcDate = Utilities.formatDate(dcDate, "GMT+11", "dd/mm/yyyy"); Logger.log(fdcDate); }
output
Execution log 10:54:59 AM Notice Execution started 10:54:59 AM Info 23/00/2025 10:54:59 AM Notice Execution completed
Description
Before opening a new issue, please
+1to vote.Description
Utilities.format date is failing and displaying wrong time.
Code
var dcDate = new Date("February 23, 2025"); var fdcDate = Utilities.formatDate(dcDate, "GMT+10", "dd/mm/yyyy")
Output
Steps
type code into app script
click run.
execute fails
click debug
output with utilities.formatDate displays incorrect date causing script to fail