Plain text to date data type

Plain text to date data type

How would I be able to set a plain text field that contains month and year("June, 2021") as a date? I am currently trying to change it in a query table by clicking the change data type button but its not allowing me  it says "it is not compatible". Is there a certain format I have to follow?