hi, i am trying to use filter control over a column of birthdate.. but i cant select dates older than 20 years… as current years is 2025.. i can max see year till 2005. Please help on the same.
i need select specific date like.. 5 sept 1993..can show last N years but not specific dates
Hi @suvarna0212
You are right. The Date filter only shows dates till 2005.
Since date of birth’s can be in random; can you approach this as a text field where the user can enter the date of birth (in a specific format) and you create a calculated field that converts that text to date. You can then create another calculated views that compares your date of bitrh column to this caluated field and return a 1 (True) if there is a match or 0 (False) if there is no match. In your visual you can create a filter on this calculated field for values that equal to 1.
So basically a workaround to get what you want.
Regards,
Giri
Why would the data filter have an arbitrary limit of 20 years? It should allow back to the “beginning of time” or something like 0000. I can actually see applications for this involved with historical documents, Genealogy, etc. What do we need to do to encourage having this fixed?