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().

Thanks,

Jeff

---------------

Jeff Johnson

jeff@san-dc.com

(623) 582-0323

www.san-dc.com

www.arelationshipmanager.com

On 03/18/2013 10:08 PM, Lew Schwartz wrote:

> Isn't the difference between two dates the numeric number of days (ie not

> a datetime)?

> On Mon, Mar 18, 2013 at 12:34 PM, Gene Wirchenko <genew@telus.net> wrote:

>

>> DATE() - {//} = 0

>

>

>

> -Lew Schwartz

>

>

> --- StripMime Report -- processed MIME parts ---

> multipart/alternative

> text/plain (text body -- kept)

> text/html

> ---

>

[excessive quoting removed by server]

_______________________________________________

Post Messages to: ProFox@leafe.com

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/51486A45.5060808@san-dc.com

** 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.