Extract years from date and use it in the filtter

[F1992]

I have  dates attributes in excel sheets from 1483 to 2019  with the below format

2019-06--23 00:00:00.0000000.I want to filter my page using only years how can
I do that ?

[Taoufiq_Zarra]

Hi @F1992 

normally this script will help you :

Year(Date#([Your_Date], 'YYYY-MM-DD hh:mm:ss.0000000')) as Year

if this is not the case share here an example of your input data and what you want as output

[F1992]

Here are my dates sample I want to show  1438,2000,2001......until 2019 in the filter

[Taoufiq_Zarra]

can share your sample data in usable format: Excel,csv,...

the expected output is a list like this is

or do you want to concatenate years like that :1438,2000,2001 ?

[Anil_Babu_Samineni]

Try this?

Load Year(Date#(Left(Field, 4))) as Year, Field From Table;