Hey there, I'm trying to pull all dates from October and another from November.
YEAR(`date`="2020")+MONTH(`date`="Oct")
My date format is different though, it has the day first, then Month abbreviated, then year(full)
13 Nov 2020
Use a dataflow to convert your text column into a date column. In Magic 2.0 you can convert date types using the INPUT tile, or you can use the equivalent in STRING_TO_DATE using date tiles.
This extra effort will allow you to use date functions in Beast Modes.