community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
Alteryx Gallery is experiencing a problem in which system emails are not being sent out. As a result, if you are attempting to sign up for a new account, you may be unable to verify your email address. We are working to solve this as soon as possible and will remove this notice once resolved.
SOLVED

calculating the date from month and year

Asteroid

Dear All,
I have month and year, I need to calculate the date will last day of the month.
Please help me with this.
My data month and year columns are like below and output is the required output
Month | Year | Output
01 |2018 |2018-01-31
02 |2018 |2018-02-28

Alteryx Certified Partner
Alteryx Certified Partner
I think this could work (not around Alteryx now):
DateTimeTrim(ToString([Year])+"-"+ToString([Month])+"-01", "lastofmonth")

Cheers,
Alteryx Partner

Hi,

Please find the solution attached along with this post.

Thanks.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
Or
DateTimeAdd(ToDate(DateTimeAdd(ToString([Year])+ToString([Month]) + "-01", 1, "months")), -1, "days")
Asteroid

Thank you so much , works perfectly fine

Labels