topic Re: calculating the date from month and year in Alteryx Designer Desktop Discussions

calculating the date from month and year

Ekta — Wed, 03 Jul 2019 06:16:04 GMT

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

Re: calculating the date from month and year

Thableaus — Wed, 03 Jul 2019 06:30:49 GMT

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

Cheers,

Re: calculating the date from month and year

grazitti_sapna — Wed, 03 Jul 2019 06:35:10 GMT

Hi,

Please find the solution attached along with this post.

Thanks.

Re: calculating the date from month and year

Thableaus — Wed, 03 Jul 2019 06:36:22 GMT

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

Re: calculating the date from month and year

Ekta — Wed, 03 Jul 2019 08:07:43 GMT

Thank you so much , works perfectly fine