Filter Collection for negative numbers

Hi,

I have a collection that i am getting through excel with a column "DateDiff". It is the calculated difference between two dates. I want to filter this collection for the DateDiff column for negative values. "DateDiff < 0" is not returning me any results. Looks like those values are getting read as positive numbers (may be because the column type is Text in collection). How can i filter these negative numbers? Help is appreciated. Thank you.

Hello Cher,

Indeed if the column is defined as Number type, you can't filter like that.
In alternative you can filter using the expression "DateDiff like '-*' ", so it will retrieve all the negatives values.

that worked!! Thank you so much. I had tried something similar but looks like the syntax wasn't correct and it kept failing. Thanks for the help.