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

[JayMappus]

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

J

[gary1 · Accepted solution]

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.

[JayMappus]

Hi gary1,

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

J