Hello,
Not sure of what your case use is but if you are trying to determine the last day of the month for an item you can determine the the next month of the targeted date and subtract one day to have the desired result. I used the following below within a calculated column. This will obviously transfer easily within Forms. Calculate Date can bring in that calculated date from the particular list item in question.
=(DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY([Today's Date])))-(1) [Today'sDate] was a date and time column with todays date set as default but you can set your intended column there instead.
I think I may have found a soultion using a substring where I replace the day with 01 and the in the next step in the work flow add two months and subtract 1 day.
Example current date is 02/15/2020 I make 02/01/2020 and then in the next step add 2 months and subtract 1 day. Result is 03/31/2020. It would be nice to figure out a way to do it in 1 step, but currently I set a variable equal to current date, format to "MM/dd/yyyy" then use the substring and replace the day with 01 and then have to add 2 monthe and subtract a day.
Maybe someone has a better way.
This is the formula I use to calculate the last day of the month in a rule to set a date field:
dateAdd("days",
dateDiff("TotalDays",dateNow(),date(
convertToNumber(formatDate(dateNow(),"YYYY")),
sum(convertToNumber(formatDate(dateNow(),"M"))+1)
,1)),
dateNow())