Hi,
I have a datatable that displays records from a Sharepoint list as below.
The second column "Date." has text values that look like dates and I would like to filter these based on the last four characters that represent the year, based on a textInput box that returns the current Year as a text value using Text(Year( Now()))
I have currently set the table to filter on;
Filter('Toolbox Talk Monthly Returns', 'Date.' = TextInput1.Text)
If I place 30/12/1899 I can get the table to filter on this date but I want to have text box display all dates with the year within TextInput1 with Text(Year( Now()))
Any ideas welcomed.
