Filter Today() is not working?

[Johan_Bertin]

Hello All,

I have a table with a column that contains the last modified date of the row that I checked as working (Below a row modified today - European format)

I created a view of my table where I would expect to it filtered by all the tasks modified today, so I applied the following filter

and the table returns no result. There are no other filters and I get the same behaviour when I apply yesterday()

Is there anything I am doing wrong or is it a bug?

Thank you,

Johan

[Connor_McCormick1]

Ah yeah that should probably be considered a bug. Good catch!

Replicated it.

As a workaround, you can try this formula:

thisRow.Modified().ToDate() 

it should work.

[joost_mineur]

Modified() is a date-time field (even if you don’t show it that way, it still is) and will never match with today, other than rows that have been modified exactly at midnight (I think). Connors ‘workaround’ should not be considered a workaround but the correct way to compare these two different fields.