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.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
I am trying to create a formula to do two things: 1- filter out any content that doesnt belong to the current month and 2- exclude any days that come after the last thursday available. For example, if I'm running the workflow on monday 1/20, i need it to exclude any days that come after last thursday (1/6). the first part of the formula (that selects current month) works properly. Here's what I did:
What I can't figure out is how to do part 2. Any ideas?
The first part does essentially what you already have rolling (just a different approach, both should work), the second part checks what day it is today, then backs it up to the last Thursday and filters based on that. Let me know if you'd like a workflow to get a better idea.