Specific dates formula

[Belletmns]

Hi All,

What formula should I use to get below:

1. Every 1st day of the month

2. Every 15th day of the month

3. Every 16th of the month

4. Last day of the month

Date format should be in DD-MM-YYYY

Thank you!

[JosephSerpis · Accepted solution]

Hi @Belletmns I mocked up a workflow that I think produces what you are asking for let me know what you think? I would add that Alteryx only recognises dates as Date data format if its in format of YYYY-MM-DD. You can though format your date into any format you like but they will need to be string format. Also to use datetime functions in Alteryx they need to be YYYY-MM-DD format. I showcased on how to do that in my workflow.

[Belletmns]

It works! thank you so much

[Belletmns]

Hi Joseph,

How to change if I want it to be current month 1,15,16 and last day?

Thank you

[JosephSerpis · Accepted solution]

Hi @Belletmns you can use the function DateTimeNow() I amended the workflow which showcases how to adjust the formulas.