I am trying to connect Gmail with google sheets and in particular I am updating in the google sheet the date of last interaction via email.
To do that I am trying to compare whether my new email record is older that the record in the database. And this is where issues start:
Even though timestamp in Gmail is in standard format (and correspondingly in google sheets also, as they are populated originally through email timestamps) simple comparison of 2.data Time operators: Less than/More than 21.Timestamp produce somehow random results. Sometimes they are correct, sometimes not. But even if I cover them in parseDate(2.date) and parseDate(21.Timestamp) still produce random results.
What puzzles me the most is that Make correctly represents the date when I do debugging and point at the proper value - yet the comparison would still be incorrect.
Any ideas what could be an issue?