No prob, David. Thanks for clarifying.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Apologies for the confusion.
I now realise that the reason that I was getting different answers (zero
in the case of the first formula) is that we speak different languages.
If I change your formula from ...,"12/31/07",... to ...,"31/12/07",...
then I get the same correct answer as using ...,date(2007,12,31),...
I should have realised, as you obviously had when you mentioned that the
latter was "the better, unambiguous way to go."
I knew that there was cases where 12/31/07 is treated as 12 divided by 31
divided by 07, but I knew that if it were treated that way I would be
getting all TRUE results from the condition, but I wasn't wide enough
awake at the time to realise that it was presumably treating 12/31/07 as a
string in this case, and hence the date comparison was always coming out
FALSE.
--
David Biddulph