Need to pull specific months from my Date column using Beastmode

Options
leeloo_dallas
leeloo_dallas Member
in Magic ETL

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 Coach
    Answer ✓
    Options

    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.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Answers

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach
    Answer ✓
    Options

    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.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Categories