So the challenge with the TimeStamp is that the transaction entries will include a Transaction date already (the transactions will be bulk loaded and then trend analysis will be done).
I thought about converting the date to an integer using the formula I found here…
Year(Date)*10^4
+Month(Date)*10^2
+Day(Date)
But got stuck trying to sum the transactions for a specific day AS WELL AS all previous dates (but non of the future dates). The idea would be as follows…
Date : Amount : Balance as of this date
3/1/22 : $10 : $10
3/3/22 : $13 : $23
3/4/22 : -$5 : $18
3/6/22 : $100 : $118
3/7/22 : -$25 : $93
3/9/22 : $55 : $148