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.

Date Time

Accepted answers

atcodedog05

Hi @SJDC

Here is the formula for it

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

Workflow:

Hope this helps : )

How to filter month to date data.yxmd

All comments

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.