Derive a date's last day of month

[Saurabh_Rana]

I have a date column like this -

Joining Date

03/01/2020

24/09/2020

25/07/2019 

I want to derive the last date for the whole column like this - 

31/01/2020

30/09/2020

31/07/2019 

[ChrisNZ · Accepted solution]

DATE2=intnx('month',DATE,0,'e');

Post title corrected it is meaningless as written.