Forum Discussion

whereismydata's avatar
whereismydata
Resolver IV
7 years ago
Solved

Connect to most recent SQLlite.db in Folder

Hi,

 

I hope someone can help me :)

 

I want to connect to the most recent SQLite.db in my backup folder. Problem is, those system generated backups a named a certain way (with the date attached):

 

->\Db-folder\file_2019_22_02.db

->\Db-folder\file_2019_21_02.db

->\Db-folder\file_2019_20_02.db

 

So, I guess you see where this is going. I need to find a way to always connect to the most recent db. Connecting to the folder, like with csv files, does not work. Connecting to a SQLite.db does work, btw.

 

Files older than three days are deleted, if this is relevant.

 

Thank you 😊

2 Replies