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
Solved! Go to Solution.
When you import the data into Alteryx, is the column given a Date or DateTime data type, or a string data type?
Thank you so much for you help
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")) ?
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