cancel
Showing results for 
Search instead for 
Did you mean: 

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

JayMappus
Deputy Chef III
Deputy Chef III

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

1 ACCEPTED SOLUTION

gary1
Executive Chef II
Executive Chef II

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.

View solution in original post

2 REPLIES 2

gary1
Executive Chef II
Executive Chef II

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.

Hi gary1,

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

J