Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Compare two dates, calculate days between without regards for Seconds?

972270Nov 4 2012 — edited Nov 5 2012
I 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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details