I have a problem.
I want to export an excel file with some column as date and I want that Excel can use the standard capabilities on this field (example: automatic aggregation by month using the filters).
Which function I need to use?
I tried to use:
date(): when I open the Excel it has the date columns in number format
format(date_as_number, ‘MM/dd/yyyy’): when I open Excel it has the date in text format