[thelist] Access Date Trouble
Joel D Canfield
joel at spinhead.com
Tue Dec 18 09:30:23 CST 2001
Mike -
I've always used MSSQL for my backend, and I'm finally in a sich where I
have to use Access. I'd love your date functions if you'd like to send
'em direct.
Thanks!
Joel at spinhead.com
-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org] On Behalf Of Mike King
Sent: Tuesday, December 18, 2001 7:27 AM
To: thelist at lists.evolt.org
Subject: RE: [thelist] Access Date Trouble
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