Converting ISO date to date. format

[JulieB]

I have a dataset with dates in E8601DA10. format.  I looked this up and it seems it's an ISO date.  I have not worked with this format before.  I have a lot of data and need to search for rows with dates occurring in 2020 or 2021.  Can anyone tell me how to search for dates in this range using the format I have, or help me convert to the more conventional date. format which I am more comfortable working with?

[ChrisNZ · Accepted solution]

A format only affects the way a value is displayed. The value remains the same.

If your value is a SAS date, you can use it as you are used to, regardless of the format applied. In your case, it looks like you should use the year() function.

[JulieB]

Thanks - very helpful!