What is a one sentence summary of your feature request?
Standardize date formats in query results
Please describe your idea in detail. What is your problem, why do you feel this idea is the best solution, etc.
When running queries where there are several “date” fields, the dates can be in different formats. This makes it complicated when exporting the report and having to manually reformat the date so that the report can be easily read and the data can be manipulated. The software should interpret the date in a standard format for queries, like it does in other pages of the UI for the properties with ‘DateTime’ format.
How do you currently solve the challenges you have by not having this feature?
The current workaround is to create another property in string format. For this property, you can add a C# expression to format the source date. You can name this property like ‘FormattedStartDate’ or ‘FormattedEndDate’ for example.