Running this, for example nightly, is per system a little different.
Depending on where JellyFin (server) is running:
- Linux/QNAP/macOS: use cron (see this guide how to use cron) or
- Windows: Task Scheduler (maybe this Task Scheduler guide is helpful for that) for this.

You'd probably need to modify the script so it uses absolute paths, and place the script in a proper location.

Note that this needs to run on the server of course.

Hope this helps 😊 

Hey @hans, sorry for necro'ing this thread, but can this task be automated for windows to run every night? Any help with that?

Maybe this explains it better ..

The "Latest Movies" or "Latest TV Show Episodes" are listed by the date they were added, which is understandable - this way we'd see the most recent additions (Netflix for example does this as well).
However when setting up your initial library, you may be adding a very old movie, which then would appear in the beginning of the "latest" list as well.
This is something I would rather not see.

Instead I would have preferred to see a "most recent released" category to movies and TV shows.
Bets would be to have this additionally ... so we can see both "latested added to the library" and "most recent released".

So what the query does: it updates the "date added" field to the "release date" value.
This temporary work around would now make it that the list shows most recent release videos and not most recent added videos.

In the long run, this may not be needed anymore - depending on your preferences and the future development of JellyFin.

For now, I run this every night, until I have my library the way I want it 😉 
Hope that makes sense ...

Perhaps I did not understand very well how to do it and that it was necessary to have a library and  So this means that my current library is the one that is going to be changed.

That means that every time I add a new title I have to run this Script?

Should show something like this (name and version different of course on your system, shown on the leftside)

Server: MyQNAP
Version: 10.7.7
Operating System: Linux
Architecture: X64

Here you will find some directory info as well, where you "may" find the correct library.db (on the far right)

Cache:
/share/CACHEDEV1_DATA/.qpkg/Jellyfin/CACHE
Logs:
/share/CACHEDEV1_DATA/.qpkg/Jellyfin/LOG
Metadata:
/share/CACHEDEV1_DATA/.qpkg/Jellyfin/DB/metadata
Transcodes:
/share/CACHEDEV1_DATA/.qpkg/Jellyfin/DB/transcodes
Web:
/share/CACHEDEV1_DATA/.qpkg/Jellyfin/jellyfin/bin/jellyfin-web

Are you sure you don't have a library.db stored elsewhere?
What OS are you running JellyFin on? What version of JellyFin are you running?

could you please check or edit the db please 😉 

(link to file removed)

Click the tab "Execute SQL", paste the SQL statement, and "Execute" (play) button.

SQL: 

UPDATE TypedBaseItems SET DateCreated=PremiereDate;

p.s. do not forget to close JellyFin!! SQLite only allows one user at a time 😊 

Hope this helps.

Note that SQLite is a single user database engine, so you'll need to stop JellyFin first, before you can access the data.
After that you can run a SQLite query through the command line or use a tool like Valentina (I do usually use this one - they have a free version) or DBBrowser for SQlite (also free) - all available for Windows, Linux and MacOS.