Filter Current Month

[Jeyaraj_M]

Hi,

I need to filter the current month data from the attached list

Ex: i need June month data alone based on the current date. 

From the attached have 14 records with different dates. So my expected output date is 7 records which is relating to June month alone.

Please help

[ChrisTX]

When you import the data into Alteryx, is the column given a Date or DateTime data type, or a string data type?

[JosephSerpis · Accepted solution]

Hi @Jeyaraj_M I mocked up a workflow let me know what you think?

[grazitti_sapna]

Hi @Jeyaraj_M  alternate solution to @JosephSerpis . I hope this helps.

Thanks.

[Jeyaraj_M]

Thank you so much for you help

[klaudia07]

How could I expand on this formula so that the current year only is filtered?  DateTimeMonth(DateTimeNow())=datetimemonth(DateTimeParse([Fiscal year / Period],"%m/%d/%Y")) ?

[ChrisTX]

Update the formula in two places.  Instead of using the DateTimeMonth function, use DateTimeYear.

Here is a list of all functions: https://help.alteryx.com/current/designer/functions

Chris