How to find out list of upcoming expiry items

Question

My database table: (Purchase-Details)

 

Table with value:

 

I want to find out the list of upcoming exipry medicines.

my Query:

SELECT * FROM PURCHASE_DETAILS

WHERE CONVERT(date,EXPIRY) BETWEEN CONVERT(DATE,'21-Dec-2021') AND CONVERT(DATE,'31-Oct-2022')

 

but error occur.

Please suggest me.