date into Access DB failure 1

[ralphonzo]

Trying to insert a date into the access database and it's driving me barmy. I'm sure I've done this before.

variable:

whatnow = day(date)&"\"&month(date)&"\"&year(date)

SQL statement:

sql=""
sql=sql&"INSERT INTO students (sname1, sname2, semail, smembership, spass, saddress, sdatereg) VALUES ('"&visitor&"', '"&visitor2&"', '"&visitormail&"', 1, '"&dcode&"', 'none', "&whatnow&")"
%><%=sql%><%
conn.execute(sql)

SQL output:

INSERT INTO students (sname1, sname2, semail, smembership, spass, saddress, sdatereg) VALUES ('Ralph', 'Test', 'ralph@test.com', 1, 'sNA9f214', 'none', 20\10\2010)

DB date output when redisplayed:

30\12\1899 or 00:01:26

I've tried using #s and converting to 'string' but nothing seems to get around it. How can I get the date to register properly?

 

[TheCandyman]

I've had issues with this in the past. Put this at the top of your page, it helps dates change to formats

Session.LCID = 1033


You can read more about that here:

http://www.w3schools.com/asp/prop_lcid.asp

 

[foxbox]

Maybe this is helpfull too:

http://classicasp.aspfaq.com/date-t...-delimit/format-dates-for-database-entry.html

 

[ralphonzo]

Thanks Candyman, but that just gives me a different time! |

Foxbox, I had a much better delve into the linked site that you sent, and got the dratted thing working. God knows why it used to work and then stopped doing so...almost as bad as PHP!!!

Thanks Tek-tips once again!

 

[wvdba]

whatnow = day(date)&"\"&month(date)&"\"&year(date)
try forward slash "/" instead of backward slash "\

 

[wvdba]

dates in access always have #
i tried it with forward slash and #
and it worked ok on insert.
try this:

INSERT INTO students (sname1, sname2, semail, smembership, spass, saddress, sdatereg) VALUES ('Ralph', 'Test', 'ralph@test.com', 1, 'sNA9f214', 'none', #10/20/2010#)

 

[ralphonzo]

That's cool, thanks. I actually gt it to work by using hyphens. I'll forward slash it in future though |