events created for wrong date #5
Description
when running template for affectedDate 18/06/2018 an event was created for 31/12/1899
done some debugging and found that this is due to the cell format of the time entered in the sheet.
currently program expects date+time not just time
a workaround works by:
- adding the today() function in sheet to the time
- when doing so the time needs to be entered between quotes
- add a number that corresponds to the number of days from now that is the affectedDate
- example: =today()+"07:15:00"+2