Converting years to a date data type

[BillyL14]

Hi

I have a list of years (2020,2019,etc).  I want to filter a range of dates ie. 1960 to 1971 for example. I tried to convert to dates but just found out I can't. Any suggestions on how to go about this?

Thanks

[mceleavey · Accepted solution]

Hi @BillyL14 ,

I've attached the workflow to do this for you.

Simply convert the year to a date then use the filter set to range.

M.

[BillyL14]

thanks @mceleavey 

[mceleavey]

You're very welcome.