Filtering Specific Months

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

ExampleDate.xlsx

Date Time

Accepted answers

binu_acs

@Adam_B One way of doing this

Filter_1004.yxmd

All comments

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:

Filter aug 1st to sept 30th.yxmd

MilindG

binu_acs

@Adam_B One way of doing this

Filter_1004.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703