Specific Date in Current Month

[jkorattiyil]

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.

[davidskaife]

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 :)

[jkorattiyil]

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.

[FloraF]

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!