Sum all previous dates to today with timestamp

[SonOfJeffGoldblum]

I am looking for guidance with a sum and timestamp within a set analysis or other suggestion.

I have a daily report that needs to be brought into Qlik. This report runs daily at 1:59:59.9999999am and 2:00:00.0000000am. Essentially, End date and Start date respectively. Each day these deliver a balance from start date to end date of all previous days to date.

I am looking to calculate this continuously as a sum of that balance.

Basically, today balance = sum({<BALANCE_TIME={"<=$(MAX(BALANCE_TIME))"}>}BALANCE)

However MAX() does not account for that start date. Is there a way to sum all previous dates up to today at 2am? In addition to going back each day at 2am? Option to do 1:59 today and previous days, too.