Hello,
I have a workflow pulling data from real-time data tables, related to warehouse activities.
This workflow will run every 30 minutes, and needs to reflect all activity from the beginning of the day through the current time. So, at 9 AM, the dynamic input should spit out all activity from 8-9. At 9:30, it would be 8-9:30, and so on throughout the entire day.
Is there a formula I can use in the dynamic input that would achieve this?
Solved! Go to Solution.
hello @MCDR929,
I would use a dynamic input in-db (if you can), it makes it a bit easier to code your query, something like :
select *
from table
where time between 8:30 and 9:00
with the time values calculated based on actual time
Hi @MCDR929
You can try something like this
The first formula builds the StartTime as 8:00 of the current day. The second one calculates the Current hour which is used in the 3rd EndTime formula. This one checks if your in the 1st or 2nd half of the hour and return [CurrentHour] or [CurrentHour] + 30 minutes
You'll to add in the logic for when the process runs before 8:00 AM.
Dan