topic What date/time format should be used with Scheduler app - "Wait until specified time" action? in Workato Pros Discussion Board

What date/time format should be used with Scheduler app - "Wait until specified time" action?

JayMappus — Thu, 22 Feb 2024 21:04:39 GMT

Hi,

I'm passing the Time value in from a Google Sheet to use in the Scheduler "Wait until specified time". I know it's supposed to be in Pacific time but what format should I use? I've been trying "2/22/2024 15:56:00" but it's not working. Do I need to use a formula to modify it? I feel this must be documented somewhere but oddly I couldn't find it by searching.

Thanks in advance

Re: What date/time format should be used with Scheduler app - "Wait until specified time"

gary1 — Thu, 22 Feb 2024 21:17:13 GMT

When you check the log for a Scheduler action, the timestamps are formatted like this: 2024-02-21T06:00:04.000000-08:00

I'd try to provide it in that format. You can probably use .strftime.

Also, if you don't include a time zone, my guess is it will get interpreted as UTC.

Re: What date/time format should be used with Scheduler app - "Wait until specified time"

JayMappus — Fri, 23 Feb 2024 14:06:22 GMT

Hi gary1,

Well you're right again. It worked like a charm. Thank you once again!