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?  

danilang

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 

Times.yxmd