Connect to most recent SQLlite.db in Folder

[whereismydata]

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 😊

[v-chuncz-msft · Accepted solution]

@whereismydata ,

Take a look at this post and try Table.Max in The Advanced Editor.

[whereismydata]

Hi @v-chuncz-msft 

thank you very much for taking time to respond to my question and sorry for my late respone. 

I tried applying your proposed solution but couldn't make it work.

I now use a script to copy and rename the latest .db to another folder.

thank you