How to filter month to date data

[SJDC]

Hello Team, Can someone help me on how can I filter month to date data in the below sample input file:

Thank you.

[ncrlelia]

Hi @SJDC,

There are a few ways to do this depending on your needs.

Essentially, the idea is to parse your date into a format that Alteryx recognises as a date. Then use DateTimeFormat to get the Month value, and subsequently filter the month value

I've included 2 variations of month value, that is the Abbreviated Month name and Month number. If you are filtering by a range then the month number will be better. You can refer to https://help.alteryx.com/20213/designer/datetime-functions for specifiers for other formats of month value.

Please see attached my suggested solution.

Hope it helps.

Thank you.

Best Regards,

Lelia

[binay2448]

Hope this can help ....

[SJDC]

Appreciate your help! this works! 🙂

[atcodedog05]

Hi @SJDC 

If the solution author's response helps please don't forget to mark it as a solution.

Cheers and have a nice day!

[SJDC]

Actually I just new that it captures previous year

can you help as well with the current year?

[atcodedog05 · Accepted solution]

Hi @SJDC 

Here is the formula for it

if [DateTime_Out]>=DateTimeFirstOfMonth()
then 1 else 0 endif

Workflow:

Hope this helps : )

[SJDC]

Thank you all for your help! 🙂

[atcodedog05]

Happy to help : ) @SJDC 

Cheers and have a nice day!