Send email when cell is the same date as current date

Question

I have a spreadsheet that I would like to use to manage user profiles. As part of this I need to keep track of people's first aid certification and when it is due for renewal.

A copy of the sheet can be found here.

I have set up a script to email people a reminder but I cannot work out the code actually to have the script email someone when the specific date is due. Basically when the 90 day reminder cell C15 matches the current date the email sends.

Here is my current code:

function emailreminder() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Profile"); 
var subject = "First Aid Renewal";
var message = "You have 90 days until your First Aid runs out. Please renew your First Aid certification before it expires." ;
var email = sheet.getRange("B3").getValue();     
      MailApp.sendEmail({
        to: email,
        subject: subject,
        body: message,
      });
        } 

Answer 1

You can try the following:

if(sheet.getRange("C15").getValue().setHours(0,0,0,0) == new Date().setHours(0,0,0,0)){
    GmailApp.sendEmail(email, subject, message);
  }

It is better to use GmailApp.sendEmail function