I’m trying to automate sending timesheets from Toggl Track to customers. It works, except… I cannot get the input time correct. The module has 2 inputs, “Since” and “Until”, the start- and endtime of the timesheet. This is where I cannot get it right. I basically want the report from Monday 0:00 until Sunday 23:59.
I use this function for “since" (ignore the date part… it’s the time part that’s causing me issues):
{{formatDate(addDays(addDays(now; 1); "-" + formatDate(now; "d")); "YYYY-MM-DD"; " UTC")}}
and this for “until":
{{formatDate(addDays(addDays(now; 2); "-" + formatDate(now; "d")); " YYYY-MM-DD"; " Europe/Amsterdam")}}
The time is correct in the bundle input on screen:
But, in the bundle input, it’s “2024-10-27T23:00:00.000Z”
Bundle content.txt (287 Bytes)
Unfortunately, this means Toggl creates the reporting including the day before.
I’ve used the formatDate function with both “Europe/Amsterdam” and “UTC”, it doesn’t make a difference. My organization timezone is set to Europe/Amsterdam. I was going to set it to UTC to see if that would fix it - but found that’s not an available timezone to set. I can set it to something in the UK, but that would still mess up with DST changes.
How can I get a formula to return 0:00:00 in UTC?