This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
i wrote about dates once or twice. Here's an article about Dates that you might find helpful.
You will need to convert the string into a date format that Alteryx understands. It will become the first of the month. Then you'll add 1 month. Next you'll subtract 1 day. Now you're working with a date that's the end of the month with the right number of days.
If you want a specific format of the date, you'll need to format the date as a string.
Open that hyperlink and get more help there.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.
An alternative to adding a month and subtracting a day to use DateTimeTrim([DateField],"lastofmonth"). This returns a DateTime value one second before the end of the month. If you need this converted from a DateTime to a Date use ToDate(DateTimeTrim([DateField],"lastofmonth"))