I've tried searching the forums here but the questions seem to be more about converting existing date formats to Month/Year.
My issue is - I have a string column which has a period in the format of Month/Year (e.g. JAN 2021) - If I convert to date using the Select tool - the field goes blank, and if I use the DateTime tool - it doesn't have an option to recognise as Month / Year and I do not want to add a random date at the start if I can help it.
The reason I am trying to convert is because I want to filter whatever data gets fed in to only show if the Month and Year is after a certain point e.g. after July 2020. Is there a way i can do this?
