alteryx
Hello,
I have a date formula question I am running into difficulties with. I am have a dataset where one column contains dates. The dates are the last day of the month, all months from Jan 2020 until Dec 2022. For ex, there are 2020-01-01, 2020-02-02 etc all the way until 2022-12-31, so 36 months in total.
I have a user input tool and action tool connected to a formula tool. The current input date is 2022-12-31.
While the dates include the day, I really only need a formula that picks the right months. I am trying to create formulas in which, given the current input date, do the following:
I appreciate any help. Thanks
@adriennelenker I think you need filter tools instead of formula tool, I created a workflow based on your requirement. I used the date tool instead of text tool