We are using smart service Export SQL to Excel in Appian to generate Excel report. All columns are retrieved as expected but only date columns are transformed into Text fields and applied filters in Excel are Text not Date related. If columns are taken directly from database it works fine but presented formatting is Excel is "MM/DD/YY HH:MM:SS" but our requirements are that all date fields have to be presented as "DD.MM.YYYY HH:MM:SS" . Using TO_CHAR or TO_TIMESTAMP functions didn't work again exported date columns are formatter as a text. Columns which are part from the CDT are Date and Time format as well. Do you have any idea how we can convert date fields to the mentioned format without losing date format after export to Excel?
There is a similar topic but without any answers: Appian Community. Thank you!
Discussion posts and replies are publicly visible
First note is that the Export SQL to Excel component (Excel Tools plugin) has been deprecated, thus it is recommended to migrate towards the Export Data Store Entity to Excel service.
Otherwise if you require specific formatting for export, typically this is done by creating a view in your database which handles the formatting, then export based on a Data Store Entity pointed to the view.