Filter array comparing dates

[Alberto_Serrano]

I don´t know what is happen with my flow,

I done a run test and it was function normal but now when I try to run the flow show me this:

And this is my complete flow:

If someone could help me, I appreciate it.

[Jcook]

Hello,

The problem most likely persists within your excel file..

For example if the column is of date format than you must convert the serial date to a real date,

You can use the expression ‘addDays’ to convert serial date.. example below:

@addDays('1899-12-30',int(<your serial date here>),’yyyy/MM/dd’)

--Josh

If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[v-alzhan-msft · Accepted solution]

Hi @Alberto_Serrano ,

The expression for the Fecha a produccion column is wrong.

Please use the correct expression for the column, you could take a try with my step1,2,3 below,  then copy the expression and use it in your flow:

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.