30-minute data pull

[MCDR929]

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?  

[Ladarthure]

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

[danilang · Accepted solution]

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