[thelist] Access Date Trouble

Paul Backhouse paul.backhouse at 2cs.com
Tue Dec 18 05:05:38 CST 2001


Hi people,
	    I am very close to taking my spare sledge hamemr out and proceeding in
smashing to a pulp my Pc - mainly Microsoft Access and anything related to
it.

The problem I am having is when I am adding a date value to a press release
I am adding in an Access Database, the database for some reason reverses the
format of the value "Now()"

The query I am using is:
strQuery = "INSERT INTO tbldata (Title, Content, SectionId, idate) VALUES
('"& Title &"', '"& Content &"', "& Sid &", #"& Now() &"#)"

The date should be written in the database like: 18/12/01 15:47:47
But for some really wierd reason its displaying it: 01/12/18 15:47:47

I've put a Session.LCID = 2057 at the top to define UK date and I have
checked all my pc settings, theres no obvious reason why this is happening.

I have even reinstalled Access to no avial - I have tested the database on a
demo site and it works fine and does exactly what its supposed to - anyway
has anyone got any idea what the hell is going on and how to stop it and its
driving my insane!!

Cheers

Paul Backhouse





More information about the thelist mailing list