SQL query - how to select 'Date added to my collection'?

BooTheMightyHamster

I'm trying to build a query to list out all the sets I've bought (and therefore added to my collection in the Brickset database) since a particular date.  While I can browse 'My sets' and order by 'Date added', I suspect that's ordering by the date that the set was added to the Brickset database, not the date I added it to my collection.

Anyone know if this is do-able, please?

Thanks!

Boo 

Huw

It's not possible. The date you added it is not recorded,  to keep database size down.

Sorry!

BooTheMightyHamster

No worries!  Thanks @Huw

How's it going?  Any punctures yet?  

Paperballpark

Huw said:

It's not possible. The date you added it is not recorded,  to keep database size down.

Sorry!

Are sets in the DB list for each person ordered by when they were added? So for example the second set you add will be in the DB list after the first set, and before the third set. Or does it not work like that, and it simply crossreferences to the main DB which sets you own? I suspect it's something like the latter.

Huw

Yes and you can order by that in the query builder but if you want a set before owning it then it'll be shown in the list out of order.

Paperballpark

Ah I see!