Hi,
I know this problem has come up probably 1000x but I still can't find a resolution that works for my case. I am trying to create a vacation/time off form.
My flow follows this path:
The problem lies in the calendar part.
Since all date/time defaults to UTC and I'm in NY (Eastern time), it's adding the entry to the calendar 4 hours earlier. For example, if I put in a vacation request for Oct 5 to Oct 6, it's showing on the calendar as Oct 4 at 8pm to Oct 5 at 8pm.
Does anyone know what I could do to overcome that? I've been trying a bunch of things but can't get it to work properly, including converting time zone. Odd that time zone is not an option in Create item.
Thanks for any help you can offer.
Solved! Go to Solution.
Hi @wookietv,
Since UTC saves the time in Calendar for four hours earlier than the time the user submits, you could try to edit the start and end dates submitted by the user using the Expression---addHours() function.
For example, addHours(‘start date’, 4) will be saved in Calendar for the same time as the actual submission.
I did a test on my side, adding Dynamic content to addHours() plus the time difference. It work, as below:
When I submitted the time at 2018/10/10-2018/10/11, the correct time was recorded in Calendar:
Please take a try and let me know if issue still exist.
Best Regards,
Barry
Hi @wookietv,
Since UTC saves the time in Calendar for four hours earlier than the time the user submits, you could try to edit the start and end dates submitted by the user using the Expression---addHours() function.
For example, addHours(‘start date’, 4) will be saved in Calendar for the same time as the actual submission.
I did a test on my side, adding Dynamic content to addHours() plus the time difference. It work, as below:
When I submitted the time at 2018/10/10-2018/10/11, the correct time was recorded in Calendar:
Please take a try and let me know if issue still exist.
Best Regards,
Barry
Hi,
Thank you for the reply.
I tried what you suggested, and it is working quite a bit better.
I just wish it didn't use times at all and can be flagged as an all day event.
Submitting a form that has vacation start date and end date (for example October 17 start to October 19 end), the end date is being put at Oct 19th at midnight. So on the calendar, it shows only 17 and 18 as blocked off.
I guess a workaround is rephrasing the end date as "What day will you return?"
Thanks!
User | Count |
---|---|
67 | |
52 | |
48 | |
30 | |
20 |
User | Count |
---|---|
26 | |
23 | |
23 | |
22 | |
22 |