Topic: SQLQuery with localized date format
Does anyone knows a trick to display the result of SQL query including a date to be displayed in the localized date format the same way it does when using the auto display in a grid?
I already know how to force a date format with strftime with Sql but it becomes strange when the app displays a mix of date formats depending on how the grid has been designed, whether with autogrid or with an Sql query button/auto search.
This is important to me as I want the app to be international so I wonder what is used within MVD to display the date in local date format in the autogrids.