Date & Time of Scenario Next Run Time?

How To
1

Is it possible to get the date and time of the scenarion next run time?

For eaxmple I have a scenario that runs every 195mins betweem the hours of 6AM and 8PM every day.

My scenario updates a google sheet row with the date and time the scenario ran by using the following:

{{formatDate(now; “DD.MM.YYYY HH:mm”)}}

I want to update another column in my row with ‘next update’ date time and day.

I could use

{{formatDate(addMinutes(now; 195); “DD.MM.YYYY HH:mm”)}}

however when the last run happens before 8pm it will incorrectly set the next runtime +195min when it should be 6AM the following day.

Any ideas on how to achieve this would be appreciated. Thank you

2

Hi @martinjacksonuk
The given formula is correct , the difference could be due to variations in time zones.

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel