Localization in Dates
Hi all,
in the screenshot you see an excel file with a column called "Belegdatum" (Reciept date). It contains the dates of reciepts in format dd.MM.yyyy. QueryStorm reformates them in its GridView to "M/dd/yyyy HH:mm:ss AM/PM" which is not common everywhere in the world. I would ask you to pay attention to the localization in the gridview.
In the SQL script Query Storm expects the excel format dd.MM.yyyy. This approach (shown this, expected that) is confusing. For debugging i am adding an Sample of that excel file.
Best regards
Achim Sample.xlsx