Filter Today() is not working?

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)

image

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

image

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

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.

2 Likes

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.

3 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.