# Time difference filtering not working well

**URL:** <https://community.parabola.io/t/time-difference-filtering-not-working-well/1396>\
**Category:** Ask a question\
**Created:** [December 15, 2020, 8:58am UTC](https://community.parabola.io/t/time-difference-filtering-not-working-well/1396 "2020-12-15T08:58:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gabrielle\_Lods](https://avatars.discourse-cdn.com/v4/letter/g/58f4c7/32.png) [@Gabrielle\_Lods](https://community.parabola.io/u/Gabrielle_Lods)\
**Post date:** [December 15, 2020, 8:58am UTC](https://community.parabola.io/t/time-difference-filtering-not-working-well/1396/1 "2020-12-15T08:58:51Z")

</div>

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’écran 2020-12-15 à 09.10.54](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/4/4f09bdd1791741ce443d06ae196d9179c8605bf2.png)

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

Many thanks!

---

<div class="post-metadata">

**Author:** ![daniel](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/daniel/32/732_2.png) [@daniel](https://community.parabola.io/u/daniel)\
**Post date:** [December 15, 2020, 10:32pm UTC](https://community.parabola.io/t/time-difference-filtering-not-working-well/1396/2 "2020-12-15T22:32:08Z")

</div>

Hey @Gabrielle_Lods 👋

Try using a [Find and replace](https://parabola.io/transform/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!

---

<div class="post-metadata">

**Author:** ![Gabrielle\_Lods](https://avatars.discourse-cdn.com/v4/letter/g/58f4c7/32.png) [@Gabrielle\_Lods](https://community.parabola.io/u/Gabrielle_Lods)\
**Post date:** [December 17, 2020, 7:13pm UTC](https://community.parabola.io/t/time-difference-filtering-not-working-well/1396/3 "2020-12-17T19:13:27Z")

</div>

It did the trick, thank you!
