Time difference filtering not working well

Ask a question
1

Hello!

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):

Capture d’écran 2020-12-15 à 09.10.54
Capture d’écran 2020-12-15 à 09.10.542372×1358 233 KB

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

Many thanks!

2

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!

3

It did the trick, thank you!

2 Likes