New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

events created for wrong date #5

Open

stepvda opened this issue Jun 18, 2018 · 0 comments

Owner

stepvda commented Jun 18, 2018 •

edited

Loading

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment