davepar / gcalendarsync

Apps Script for syncing a Google Spreadsheet with Google Calendar
MIT License
161 stars 46 forks source link

Doesn't Create new events, getting 'invalid argument' error. #32

Open bowman153 opened 6 years ago

bowman153 commented 6 years ago

Hello! Love the calendar, however recently i have been having an issue. the calendar does not create new events. the calendar worked great until i migrated everything to a different sheet. ive checked spreadsheet location and all time zones match, and it is going to the correct calendar; im unsire what to do.

the error in question "Invalid argument: date_ms: 0x23f65f4feb000 (line 397, file "Code")

The aforementioned line 397; newEvent = calendar.createAllDayEvent(sheetEvent.title, sheetEvent.starttime, sheetEvent);

Hope you can help, Thank you!

davepar commented 6 years ago

I'm not certain what is causing that error. Did you set the format for the start and end time columns to "Date time"?

bowman153 commented 6 years ago

Thanks for getting back to me, and I have yes. I’m British, so I’ve set the format to D/m/yyyy in the code, and in the spreadsheet location, and also in the start time, to my local format. It worked like this before, and this error has just suddenly arose.

On Sat, 27 Jan 2018 at 6:40 pm, Dave Parsons notifications@github.com wrote:

I'm not certain what is causing that error. Did you set the format for the start and end time columns to "Date time"?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/Davepar/gcalendarsync/issues/32#issuecomment-361005624, or mute the thread https://github.com/notifications/unsubscribe-auth/AhqUNLQKxbRWVuMTEbd4VjNuAmzLFu17ks5tO22CgaJpZM4RuC4r .

--

Kind Regards,

Jack Bowman

Prasinus Holdings Ltd

T: +44 (0) 1347 878 066 M: +44 (0) 7854 941 502

E: jb@prasinusholdings.com W: www.ecourea.com

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.