LiranE

June 13, 2015

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 ;

Posts posted by LiranE