Forum Discussion
ScottDye
2 years agoQrew Trainee
I forgot to add, this would need to trigger TRUE within the 6:00 hour only M-F, not weekends.
------------------------------
Scott Dye
------------------------------
ChayceDuncan
2 years agoQrew Captain
You can use strftime with something like this so it's nice and easy to read:
%w returns the weekday index with Sunday = 0 and Saturday = 6 so those are omitted, and then %-H returns the current 24 hour value of the current time. Keep in mind that Pipelines runs on UTC time for conversions so you need to convert 6:00 AM to UTC time for your filter. 6AM EST is 11AM UTC so you would put 11 instead of 19 from my screenshot.
------------------------------
Chayce Duncan
------------------------------