Hi,
I know this is an old chestnut, but I just can't understand why this
function returns "0" -

iif(cdate("08/03/2005")>cdate(date()), 0, 1)

Todays date is "03 July 2005". My regional settings are set to
"DD/MM/YYYY". If I change the first argument to "08 March 2005" I get
the same result.

Any Ideas - this is driving me screwy...

Thanks,
Peter

Try iif(cdate("08/03/2005")>cdate(Now()), 0, 1)


Gunnar
--
Not a Guru


"Peter" wrote:

try the format : YYYYMMDD (20050308)

"Peter" <peterr (AT) intellimaxsolutions (DOT) com> wrote

wow - it actually worked, I have no idea why though.

It looks like the 'Date()" function always returns a date ini US format
ie. MMDDYYYY, whereas the "Now()" function is sensitve to regional
settings.

Thanks for the tip anyway.

Cheers,
Peter.