Trimming date to show only month number

[ryanmeighan95]

Hi All,

I'm relatively new to this so apologies for the poor understanding of Alteryx.

i've got a pile of data that is currently showing as a full date. however I want to use a formula to show anything that relates to '03' to go through as true and anything else as false.

any help would be appreciated.

thanks!

[atcodedog05]

Hi @ryanmeighan95 

You can use datetimemonth() formula which will give you the month number.

Hope this helps🙂

[atcodedog05 · Accepted solution]

Hi @ryanmeighan95 

Your formula and filter would be something like this.

Hope this helps 🙂

[ryanmeighan95]

worked perfectly! thank you so much! 🙂