Filter by fifo date over 30 days

1

Hello,
I’m trying to create an aged inventory widget that filters inventory with a fifo date older than 30 days. I’m not seeing a range that accomplishes this. Anyone have a suggestion on how to accomplish this?

Thanks!

2

Hi!

You can use a calculated field in the Display Stage of the widget builder to add a condition that will help you filter the data. The following condition creates a new column with a flag value of 1 for any row having a date value older than -30 days. You can then use that column to select only the data that has a value of 1 and display it in your widget.

condition(lessThanOrEqual(YOUR-DATE-FIELD,sysdate(-30)),1,0)

Thank you

3

Thank you!