Need to pull specific months from my Date column using Beastmode

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

Best Answer

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤
    Accepted Answer

    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.