I have tried every way I can possibly think of to get .start to work and set the HH:mm:ss to 00:00:00.
https://httpbin.org/get?{date.tz("Europe/London").format("yyyy-MM-dd'T'HH:mm:ss'Z'")}
Can anyone help?
Thanks,
Andy
I have tried every way I can possibly think of to get .start to work and set the HH:mm:ss to 00:00:00.
https://httpbin.org/get?{date.tz("Europe/London").format("yyyy-MM-dd'T'HH:mm:ss'Z'")}
Can anyone help?
Thanks,
Andy
Hi Andrew,
You can hardcode the time to 00:00:00 in your query, if your time never changes as below. It's generally the best approach if the time never changes:
https://httpbin.org/get?{date.tz("Europe/London").format("yyyy-MM-dd'T'00:00:00'Z'")}
Or you can use Set() function as below. The following retrieves data from today at 00:00:00 London time (start-date) to the current date at 00:00:00 EST (end-date), both in the default yyyy-MM-dd format.
https://httpbin.org/get?start-date={date.tz("Europe/London").today}&end-date={date.set("00:00:00","HH:mm:ss").today.format("yyyy-MM-dd'T'HH:mm:ss'Z'")}
Hope that helps!
Shima