Filtering Specific Months

[Adam_B]

Hello Alteryx world, 

I have a data set attached that has random dates from 2020-2022.  I would like to only filter from August 1, 2022 through September 30, 2022.  I have seen many different ways throughout the discussion boards, but none that fit me needs.  Any assistance would be appreciated. 

I have tried this, but it has not worked:

Thanks, 

Adam 

[DataNath]

@Adam_B your dates are coming in in the correct format so no need to parse them. You should just be able to use a basic filter, leveraging the date range like so:

If you hit 'Custom Filter' you can see the expression that is automatically generated by this. Alteryx works with dates in YYYY-MM-DD format and so you just need to type in your date boundaries in this form if you're going to manually enter one:

[MilindG]

[binuacs · Accepted solution]

@Adam_B One way of doing this