Need to Change data type string to date - current column contains date in format of "Year - Month" in Bigquery as string type,need to change datetype

This is my bigquery table schema, enter image description here

when i try this below code. """SELECT CAST(_Time_Period AS DATE) AS Date_Period,* FROM project.ABS_data.abs_visitors"""

got error of - Invalid date: '1975-07'