Hi,
I have this problem :
I am using google script with sheets and I can't find a way to get the number of days between due date (from the sheet) and current date.
I want to send alert when current date is less then 30 days from due date.
maybe its related to the format of the date ? ( Sat Jun 13 2015 08:02:04 GMT+0300 (EEST))
please help,
function CheckedDatesToAlert()
{
var sheet = SpreadsheetApp.getActiveSheet();
var data = sheet.getDataRange().getValues();
var sub = "Alert" ;
var CurrentDate = new Date();
var email = Session.getActiveUser().getEmail();
for (var i = 1; i < data.length; i++) {
var expireDate = data[6];
if (CurrentDate.toDateString() < expireDate.toDateString()) {
var subject = sub ;