I have never felt so frustrated!!! I tried to troubleshoot for 2 day but nothing seems to work and i have been checking countless forms and reddit page no answer to my question.
I have a simple Excel file and I have formatted the dates in yyyy-dd-mm now there's two columns in my excel sheets with dates one is called "Transaction date" another is called "Due date" both formatted is the same way.
I have used the compose function to format the date to 'd' i will share screenshots below. Now it converts transaction date but does not recognize the due date even though it's formatted the exact same way.
Step 1: You can see I choose datetimeformate: ISO 8601
Step 2:
in excel the format is yyyy-mm-dd for both transaction type and due date
Step 3:
when i run the flow i get the following error message only for Due date which is compose 2 even though compose and compose 2 are exactly the same format. can someone help me understand the issue?
Share
Report
All responses (
Answers (
525
