First date of next month

[wonka1234]

Hi,

I am trying to use my "End Date" to get the next first date of the month,

Ie. End date = "6/30/2022" ,  and want my "Field Start Date" to be "7/1/2022". 

However I am getting null!

How can I fix this?

[ztriano]

Try changing the Data Type to Date. I did that and it worked for me, but you need to make sure that the column called End date is in date format already and if it's not, you'll need to pass it through the DateTime tool.

[christine_assaad · Accepted solution]

Hi @wonka1234 

Alteryx needs the date to be in ISO format YYYY-MM-DD

You will need to convert your date to this format using Date time tool as below

You will then need to use the formula to calculate first of following month and if you want, you can format the output (in this case it will show as text instead of date)

Attached is the WF to help as well. Cheers!