[thelist] Access Date Trouble

[Mike King]

Access _should_ store dates in the correct format, but it's is a law unto 
itself... it stores dates in such a fuck-up way that I've almost given up 
using it. (if you can, try using MSDE)

Always send your dates by formatting _each_ date part _everytime_ ie.

MyLovelyDateIn = Year(now) & "-" & Month(Now) & "-" & Day(now)
MyLovelyDateOut = Day(RS("Date")) & "/" & Month((RS(Date)) & "/" & 
Year(RS(Date))

It's the only thing that's ever worked for me!
(I have got a couple of nice functions for dates if you want them?)

Cheers
mk

At 13:52 18/12/01 +0000, you wrote:
>Rudy,
>         no go, didn't like the code.
>I'm convinced its Access being a microsoft product, I've probably got a
>corrupt file somewhere.
>Don't think I'm going to be able to fix it.