Hi. I am comparing dates on a couple of different files and if those dates become out of balance by more than our 2 day buffer time, someone needs to react. I was hoping to handle this with an IBM green screen query based report, which works for the most part but when the two dates split over a month end (April 30 and May 1) then the math gets skewed. For example: If DATEA = 115/05/01 and DATEB = 115/04/29 I would expect a 2 day difference but the result is actually 72. If I create a field called NEWDATE that caculates [DATEA - 2]; the result is 1,150,499 instead of 1,150,429. Screen Shot included QryDate.pdf
I was wondering if there is still any way to calculate the difference between DATEA and DATEB in query?
Dates are in CYYMMDD (115/04/23) format.