Select records by MAX(time) - 90 days

[Gary Ehrenfeld]

I have a sqlite3 database that has data downloaded from my diabetes meter. I download the data from the meter daily.

I now do a calculation on the database using every record in the database.

What I need to do is get a list from the database that comprises all the records that are from the last date that was appended minus 90 days to the last append record.

example: Select * from meter where time > last append time -90 days

Hope I made sense of what I need to do.

Thanks

Gary