On May 24, 2006, at 1:35 PM, Duane L. Mitchell wrote: > On 5/24/06 11:51 AM John Baxter [log in to unmask] said: > >> Subject to correction, of course, I'm reasonably sure that the >> problem is not with >> current date >> but with the value compiled into pReferenceDate. > > OK so pReferenceDate would have to compile into a number larger > than current > date in order to make the result negative. > > -Duane Mitchell > Fun trivia date "Friday the 13th" actually compiles. Doesn't do what you think though. -Mark Who uses dates that are in the future and sometimes does get negative numbers subtracting times.