google apps script - Values Match if not being met :S -

google apps script - Values Match if not being met :S -

function unupdatedrows () { var ss = spreadsheetapp.getactivespreadsheet(); var formsheet = ss.getsheets()[0]; var numrows = formsheet.getlastrow(); var lastrow = formsheet.getrange(numrows,1); var lastdate = lastrow.getvalue(); logger.log(lastupdate()); logger.log(lastdate); if (lastdate == lastupdate()){ logger.log("match! sheet date"); } }; logger output: [14-06-24 16:12:53:188 edt] mon jun 23 01:50:10 gmt-04:00 2014 [14-06-24 16:12:53:188 edt] mon jun 23 01:50:10 gmt-04:00 2014

i should seeing "match! sheet date" in logger too. why isn't if statement beingness met?

avoid checking equality on date objects, never equal (you can utilize > , < comparing though), on string representation instance or derived value (year, month, day, hours...) or on native values (millisec).

google-apps-script google-spreadsheet