How to select records by date and add values in sqlite?
I need to determine which records are within a date range and sum the values of the records that are within that date range
Example data:
For example, I need to know the sum of the values between the dates 02/04 and 03/04
TIMAI2
2
I would store my dates like this 2024-03-20....(probably as a string not a date number)
Once you have your queried records returned, as a list, you can iterate over these to "add values".