calculating the date from month and year

[Ekta]

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

[Thableaus]

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

Cheers,

[grazitti_sapna · Accepted solution]

Hi,

Please find the solution attached along with this post.

Thanks.

[Thableaus · Accepted solution]

Or
DateTimeAdd(ToDate(DateTimeAdd(ToString([Year])+ToString([Month]) + "-01", 1, "months")), -1, "days")

[Ekta]

Thank you so much , works perfectly fine