LiranE

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 ;