Hi,

Today, 01-07-2005 (jan. 7th. 2005)

Using vba!Date() in AS returns 01-07-2005 (juli 1.th. 2005). This is not
just american style, because dateadd("d", -1, date()) returns 30-06-2005
(june 30th. 2005)

Does AS really mix up day and month???

From SQL using getdate() as well as from MS Access using date(), the correct
date is returned.

Regards,
Lasse

Hmmm - I get the correct value: 01/06/2005 (US locale) when I try it.
What does DateSerial() return in your case?

DateAdd("d", -1, DateSerial(2005, 1, 7))


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

DateSerial() returns the correct value. Now() also works fine.

Today (8th. jan), Date() returns 1. august.... Wonder what will happen the
13th jan.?

Regards
Lasse

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> skrev i en meddelelse
news:OfdEXsQ9EHA.3588 (AT) TK2MSFTNGP10 (DOT) phx.gbl...