EOMONTH equivalent in Google Scripts

Question

I'm writing a script that doing some date manipulation and I need to know how many days between current date and end of the month.

I've already got a function that I can put two dates into and it'll return the number of days between the two dates.

I'm looking for an equivalent of EOMONTH in scripts so I can return the date of the last day of any given month (Hope that makes sense)

All I've been able to come up with so far is adding a day to the date until it becomes a new month and running a counter whilst doing so, but this just seems a really silly way of doing it.

This might help: https://stackoverflow.com/questions/315760/what-is-the-best-way-to-determine-the-number-of-days-in-a-month-with-javascript. — General Grievance, Apr 28 '21 at 14:37
perfect thanks! Don't know why my search didn't come up with that — Michael Liew, Apr 28 '21 at 15:08

score 1 · Answer 1 · answered Apr 28 '21 at 16:22

1

function daysInMonth(m=0) {
  return new Date(new Date().getFullYear(),m+1,0).getDate();
}

answered Apr 28 '21 at 16:22

Cooper

59,616
6
23
54

A very clever way of getting the EOM. – NightEye Apr 28 '21 at 16:39

EOMONTH equivalent in Google Scripts

1 Answers1