Google Sheets FILTER formula greater than TODAY()

Question

I want to filter the responses to a Google Form, so as to view only the rows with dates greater than Today() in Column I.

I'm using:

=filter(dates!A:J; dates!I:I > TODAY())

But no rows are being filtered out.

I'm suspecting that the arrayformula in Column I is causing the issue. This arrayformula creates the date i'm trying to filter from columns B,C and D

demo file: https://docs.google.com/spreadsheets/d/1BOuyQAGh4rVFfk8yL5zcuJBUFXPtOdAZz14JSr66AtE/edit?usp=sharing

any idea?

Answer 1

try:

=FILTER(dates!A:J; dates!I:I*1 >= TODAY())