Hi,
i´ve been using a power automate flow for some weeks now, which basically runs a SQL query from our database and writes the results on an excel file which then is sent via email.
The main problem is that it returns two date columns, which are stored in the database in yyyy-mm-dd hh:mm:ss format. However, Power Automate writes this column in the excel file as mm-dd-yyyy hh:mm:ss, mixing with previous dates from previously executed flows from weeks ago in the correct format. I want the dates in the same format as they are in the database. This has started happening without notice from one day to another.
I´ve tried adding to the SQL Query written in Power Automate this line:
DATE_FORMAT("column", %d,%m,%y) AS "whatevername" but it gives a syntax error, BUT if i add this to the query executed through our Database manager, it runs it perfectly fine.
Can someone help me, please?
First photo shows the date column format in the database, and the second one, how it´s written in the excel file by Power Automate.
