Hey kids! I just noticed that the “Last Played Date” value on the album row, is the oldest of the matching values in the Last Played Date table, not the newest. You can see this in “album view” in the Last Played Date column. You can definitely see the bug if you’re using the “Played Year” folder - albums that I played in 2025 list as “2021”.
The last play date column indeed shows a wrong date, but only if you click one of those play years folders. (it grabs the last play date from that year it seems).
It is wrong, it is a bug, but just to let you know without using those play year folders the column should show the right date. We’ll put it on the buglist, thank you.
Thank-you! Looking further, I can see another defect.
Click on Played Year report, Played data-set in the left pane, order by Last Played Date in the detail pane.
Albums are showing here as “played” - they have “Played history : total plays (1)” but Last Played Date is blank. The expected result is that those albums only appear in the “not played” data-set. For example, I have definitely not played any of my 7” Single format.
In other cases, the Last Played Date has been lost. For example, index 414 Sigur Ros “Inni” has been played - I played it on 2025/10/04, as indicated by the Last Cleaned Date. It shows “total plays 1” (correct) but blank in Last Played Date (incorrect - should show 2025/10/04).
If if helps, I have recently deleted a small number of albums - is it possible that the index foreign key has become corrupted? For example, the album above maybe had a key other than 414 when the “played date” record was written to the other table?
I’m not sure what index foreign key means. Deleting an album is not connected to existing albums.
That is indeed strange, not sure how they got lost. If you can find a sure-fire-way to reproduce losing a Last Played Date I can dive deeper into this!
A play “event” can be added without date (edit an album, and then you can add a new play, clear the date, and save it). So an album can be Played: yes, and without a date.
But since you said you lost some dates, this might be connected to that?
Can you show me this with a screenshot where it shows wrong data for you (and also the play history in the Edit screen?)
Could it be you have recently added these and are using pre-fill and have the play date as a pre-fill field? If so, simply removing it from pre-fill settings would fix this.
TL;DR - there’s a definitive screen-shot of a defect at the end of the message.
My comment about foreign key… I imagine there is a table of “listened dates” that is related to the table of “albums” by a common Index column. Imagine I had 10 albums, and I listened to 9 of them once. I didn’t listen to album index 9. The “listened dates” table would contain 9 rows of [n] [yyyy-mm-dd], where n is the index number of the corresponding row in the album table. If I then deleted the album row with an index value of 9, and doing so caused the album rows to be re-indexed, then the result would be that the album 10 would be re-indexed to 9, and there would be no matching row in the “last listened dates”. As a user, it would appear that the listened date for album 10 had been lost. But you’re telling me that deleting doesn’t re-index, so that’s good! 
To my point about the “total plays count”, below are some examples of albums that have no “last listened date” but do have “total plays count=1”. I hear what you say that it’s possible that a listened date could be added and then removed, but for these below I am 100% I have not edited the records in any way and I definitely have not listened to the albums.
The following examples show albums I am confident that I have played and have recorded the listened dates. This screen-shot shows that three “listened dates” have been lost.This would have occured after 2025/10/02, which is the Last Cleaned Date.
Happy hunting!
regards
One more thing. I think you’re saying that any edit to the “album” record could or would cause the “Total plays count” to increment.
I often edit albums to add “Original Release Date” or “Release” date” but I don’t listen to the album. I would suggest it is a defect to increment “Total Plays Count” unless an edit has been made to the “listened date” array. Here’s an example of an album where the total plays count =1, there is no listened date, but you can see that I have edited it recently.
Thanks for your explanation. Unfortunately on my side I still cannot reproduce this.
When I edit an album that has no play history dates, it doesn’t add one for me.
Can you doublecheck your pre-fill settings in the menu? Make sure that Play history or anything with play dates is not there as it will add a play event to your played history if you have the field there.
Here’s what happens when I edit an album I’ve never listened to:
I am curious if you can video an album you have definitely not listened to, and get it to add a play history event without you actually doing that yourself
You can record your screen via this website:
https://screenpal.com/
You can send me the file(s) via:
I didn’t say that (can you let me know why you thought that? I might have to change my post).
Also it would be extremely wrong if an edit would increment the play count! But as you can see in my video above, I can’t reproduce that.