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!
Question for you. Is this Date formula the second expression in your formula tool? The error you're getting says that the second expression is the one that needs attention. As an example, in the picture below, the Count variable is the second expression in this formula tool.
And through Regex and DateTime tool - it got extracted and changed to 2020-12-07 heading is Date. In the formula preview, it looks like fine i.e i can see this date showing as Monday.
In fact, what i was trying to achieve is put a formula if the day is Monday, column EOD will be divided by 3, otherwise divided by 1. Is there any easier way just look up using date - knowing is Monday rather than creating a column with Day of the week?
Sorry, just to be clear, I wasn't suggesting adding that Count field. I was simply using it as an example to clarify my question. It is important for us to know if your Day field that you're creating is the second expression in your formula tool or not.