I’m playing around with reporting and I would like to get the record for each date between dates.
I have the StartDate and EndDate on calendars and I can retrieve data between the two selected dates but I don’t know how the grab only the last record for each date.
Below is the query I have so far.
WHERE transaction.t_stamp >= ? AND transaction.t_stamp <= ?
ORDER BY transaction.t_stamp
I’m testing at home on 8.0.10 but have an older version at work ~7.something
Any pointers appreciated.