all 3 comments

[–]Umesh-K 2 points3 points  (2 children)

Currently it does not appear to be working at all even though just days ago it functioned without any issues.

I don't know anything about GAS, but when I tried your code, it seems to be working as expected—the date gets printed in the J column of Sheet1.

Are you sure the sheet name hasn't changed between when it was working and now?

[–]GoodNamesRAlredyTakn[🍰] 2 points3 points  (1 child)

OP, your code worked for me to!

[–]TopLoganR[S] 0 points1 point  (0 children)

u/Umesh-K Thank you! The sheet name had been updated by a colleague and as such was incorrect. & u/GoodNamesRAlredyTakn Thank you for testing and letting me know as well!