Indeed, I'm setting the maximum valid value as specified in the documentation to determine the actual date/time. If you add 1 to that number it returns an Invalid Date exception. I didn't need to loop/test because for once I had actually read the manual! :-D
;-]
assume life -= .5 But don't spend too much time putting that estimate together, I have a funny feeling that this will never quite reach the top of the priority list!!!
;-]
Pete O'Hanlon wrote:
Makes sense, Div0 is ∞ Nah - it's nullity[^].
Well, if you perform the calculation within the confines of a Messagebox statement, rather than an exception, you will receive the result "infinity" and not "nullity"! Rich :)