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?