[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