This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'd like to create a workflow whereby each month, Alteryx will filter or prepare a list of action owners who need to close out their action items by the end of that month. I have my data source (Excel).I can do a manual filter and set the date, but I want an automatic (dynamic) instruction in Alteryx that will automatically set the criteria to end of the month (or last day of that month).
For sure the first part of the condition --- formula ToDate([Target Completion Date]) --- if the Target Completion Date is not in the date format, than you need to use DateTimeParse(dt,f) function to change you date to date format.
Eg. if your date is in format 18 Feb 2021, than with formula DateTimeParse([DATE],'%d %b %Y') you can change it to date format.
Is it correct to say that I must ToDate the result of DateTimeTrim because after applying the DateTimeTrim function, the output might not be recognized by Alteryx as a data format, hence I will need to ToDate(DateTimeTrim[TargetCompletionDate],"lastofmonth") ?
Just using lastofmonth will give you the last minute of the month like below 2022-02-28 23:59:59 since our date doesn't have time it wont match when we use ToDate it becomes 2022-02-28 (I,e considering only datepart). This way now it will match.