[thelist] Access Date Trouble
Mike King
mike.king at redroom.co.uk
Tue Dec 18 09:26:43 CST 2001
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.
More information about the thelist
mailing list