Also when sorting a date column it doesn't sort correctly ie;
12/01/2023
12/02/2023
11/06/2023
12/06/2023
12/07/2023
...
So i'm picking the date in the date picker (often with multiple selections) as the 7th December 2023, the date is being stored in the database as Wednesday, 12 July 2023 (no idea why it's using a long date) and then being shown in the program as 12/07/2023. Somewhere between picking the date and storing it in the database is going wrong. It's a handy program but less useful to me if date fields aren't accurate.