Having trouble to filter by Date. Have a table Entries that has to be Filtered by three columns [Track] [Date] [Race] .
No problem with the other two columns but with date, we cannot filter.
When i display the data of the slice the DAte is expressed as a Value.
In my data is with text format DD/MM/YYYY
When i do filtering i have a column Racing Date that because of one reference One to Many brings a to column concatenate key instead of the date. So to solve that we created a virtual column for the filter with a formula to extract the date from as example : 8/12/2021
The formula DATE((ANY(EXTRACT(“DATES”,[Racing Date])))) This is the Test result.
THe filter is not working. Could be that expression result must be a Date VAlue? If so.
What is the right expresion to convert a Date to a value date.