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!