Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
Here are my dates sample I want to show 1438,2000,2001......until 2019 in the filter
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 ?
Try this?
Load Year(Date#(Left(Field, 4))) as Year, Field From Table;