Gene: "date() - {//} = 0" I wrote that because that's what I see. You
mention that it makes sense to you that you shouldn't do math with an
empty date, but it doesn't make total sense to me. After this
discussion I will never do it, but it does follow some interesting rules.
VARTYPE({//}) = D
VARTYPE({/:}) = T for instance
In any event, thank you all for the discussion.
Jeff
---------------
Jeff Johnson
[email protected]
(623) 582-0323
www.san-dc.com
www.arelationshipmanager.com
On 03/19/2013 10:11 AM, Gene Wirchenko wrote:
At 06:38 2013-03-19, Jeff Johnson <[email protected]> wrote:
Lew: That is what I meant by doing the math, but it doesn't. I
would expect date() - {//} to be = date(). It probably doesn't
because it is an "empty"
date and not a valid date. As I mentioned previously I don't intend
to do math, I just want to be able to check for an empty datetime().
Since an empty date is not a valid date, why would you expect
date arithmetic on it to work?
[snip]
Sincerely,
Gene Wirchenko
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
