I know there are various topics on this matter, but no single one is covering how to change recently added date to release date on a Mac?
Anyone who’s been successful to change this on a Mac? I look for a solution I can do this for my entire library at once and not one by one for each individual media file.
If you have never worked with SQL before, I recommend you to not do the following.
In any case, shut down Plex Server, and create a backup copy of the main Plex database file which you can restore in case anything goes wrong.
UPDATE metadata_items SET added_at = originally_available_at WHERE ((originally_available_at != added_at) AND (originally_available_at IS NOT NULL));
I have indeed no experience with SQL.
Is there another way to do this or could you elaborate a bit more on the steps I need to take after I downloaded and installed SQLite?
Anyone that can help on this matter pls?
https://github.com/markbsigler/bin/blob/master/plexrecentreset.sh
I dropped your SQL statement into this bash script which works on Debian based due to file path.
If there hasn’t been a feature request, this would be a nice to have in advanced settings for Library.
is there a way to revert it back to default?
What do you consider a ‘default’ date?
i mean to revert it back to date added instead of release date?
No, the only record of that “original” date was overwritten when you executed the SQL query above.
Unless you revert to a safety backup of your main Plex database
all right thank you for clarification 
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
