Need to pull specific months from my Date column using Beastmode

leeloo_dallas

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

jaeW_at_Onyx

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.

jaeW_at_Onyx

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.