Hello - Can someone please help me to write a formula to get a spefici date of current month, example , March 20 2022 in 03202022 format.
Hi @jkorattiyil
One solution, if the date is in a specific Month Day Year format is below:
I've attached a workflow that should assist you
Thank you for your response!
However, i am looking for the date should change based on the month in which i run the workflow. if i run in April, it should show April 20th if in May, the output should be May 20th.
Hello
What you are trying to accomplish with filtering for dates with specific formatting, or just filtering out on "Current Month" data is definitely do-able in Alteryx.
I provided 2 different approaches for your convenience:
1) Add a new column for the "Current Month" with "Yes" or "No" Values
2) Re-formatting the date column to show mmddyyyy format, mentioned in your post
**If this solves the issue, please click on the like below, thank you!
