It turns out, the issue was with the database connection settings. We needed to change the login default language to “us_english” to get the mdy format in the DB settings.
ALTER LOGIN [username] WITH DEFAULT_LANGUAGE=[us_english];
Afterwards you have to disconnect and reconnect to the DB.
You can check the settings with DBCC USEROPTIONS
This also solves: SambaPOS 5 '{Start}' '{End}' Issue in Data Exports