Date Filter not working

Hi! I'm trying to filter my dataset, so I only get the rows with the 1st of each month. I want to filter out any data points that are not at the first of every month.

However, when I try to use the date filter & set start period to 1st of May and then period type to months, it still iterates the days and not the months.

How do I solve this? My date format shows up as yyyy-mm-dd. ( I also already parsed it from a string to a date, so that's not the issue)

I uploaded the dataset I want to filter on, because the website didn't wanna let me upload the alteryx file.

btc.csv

Help

Accepted answers

Aguisande

Let me share with you this, to see if I'm right:

You need to separate all day ="01" from the rest of the dataset (like below).

1st of month.PNG

To accomplish this, I used a formula to set a new field (in this case called [DAY] like this:

DAY formula.PNG EDIT 1: The type of this new field is INT16 (not shown in the screenshot, sorry)

Then I filtered all the [DAY] = 1 in the data and got the result attached at the top.

Here you can see what I made to get this:

1st of every month.PNG

Makes sense or still missing something from my side?

All comments

Aguisande

HI @altsorz

To avoid this situation, I'll use a different fields for day, month and year.

Once you got the values in three separate fields, you can use simple filter expressions to get what you need.

If you figure out how to load your workflow, I can help you applying this to your actual workflow (try a private message to see if you can upload the workflow in it)

altsorz

Thank you would be greatly appreciated! (I'll see if the file will upload in this reply )

DateConverterBitCoin.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703