Skip to content Skip to sidebar Skip to footer

Set A Trigger To Run Function The Last Hour Of Each Month

In google scripts I know there are triggers to run by date, but I don't think that will work because month's have different amounts of days. So I was wondering if there's a way to

Solution 1:

First create a trigger from project Edit > current project's trigger or register it programmatically that will run every day at 11 pm.

ScriptApp.newTrigger("myTriggerFunction")
   .timeBased()
   .atHour(23)
   .everyDays(1) 
   .create();

Then in your trigger handler, check if today is the last day of the month, then do your work.

functionmyTriggrFunction()
{
  var today = newDate();
  var lastDayOfMonth = newDate(today.getFullYear(), today.getMonth()+1, 0);

  if(today.getDate() == lastDayOfMonth.getDate() )
  {
    // your work to be done
  }
}

Post a Comment for "Set A Trigger To Run Function The Last Hour Of Each Month"