Logic apps excel date issue

Vijay Rudrasamudram 26 Reputation points
2021-01-14T10:59:50.457+00:00

Hi All

We have a logic app running in the production environment which reads from excel which has date columns and converts it to CSV. Excel dates are carried as is ie excel epoch date like 43889. This logic app is scheduled every hour and has been running fine for 2 months, till today morning 00 hrs IST the dates are getting converted to 2020-02-28T00:00:00.000Z with no code changes at our end. Are there are any changes done at the logic apps excel connector level

We are using List rows present in a table and item()?[Date] field. Is there anyway we force it to use the excel default date format

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,899 questions
0 comments No comments
{count} vote

1 answer

Sort by: Most helpful
  1. JayaC-MSFT 5,526 Reputation points
    2021-01-15T06:42:46.97+00:00

    @Vijay Rudrasamudram Is your Date column in excel, in text format?