Compare two dates, calculate days between without regards for Seconds?
972270Nov 4 2012 — edited Nov 5 2012I need to compare two dates (open date and closed date) and count the total number of whole days between them.
Any entry that that has >30 days is "overdue".
But Answers is counting the seconds as part of the calculation...so an open date early in the day, and a close date 30 days and 2 seconds later shows up as overdue.
How can I compare the whole days between? Or otherwise calculate if the second date is more than 30 days past the first date, regardless of seconds?