Filter a date formula?


I have a column with the type formula and it populates the date, but when I try to filter that date it treats it as a text, is there a way to treat that date as a date when filtering? meaning that I can filter by today or filter by date within a certain range…etc. ?

Thanks in advance!


The DATETIME_PARSE() function will turn a string into a formatted date.