Time difference filtering not working well


A section of my flow needs to send the orders placed in the past 24 hours to a .csv file.

I’ve set up an Order Time column, a Current Time column and a Time Difference column. The Time Difference column unit is days.

When I add the filtering option: Keep only Time Difference values that are 1 or smaller, the system often includes other random values (see first 2 lines):

How can I fix it to ensure only the right orders are included?

Many thanks!

Hey @Gabrielle_Lods :wave:

Try using a Find and replace step on your Time difference column to replace all commas , with a decimal . value.

You should now be able to keep rows where the Time difference is less than or equal to 1.0

Let us know if that works!

It did the trick, thank you!