Hello all, i know this is probably simple, but i'm burnt out. i have a field in my access database that's a Date/Time format. i'm trying to insert a new record from an asp form, but i keep getting the type mismatch error. How do i format the data coming from the form to be a date format? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Formatting a date to go into an access database
- Thread starter gmagerr
- Start date
I always convert it into a format like 26-Jan-2002 to ensure there are no confusions between month and day (some countries write it in month/day/year format, or year/month/day).
Then just remember to wrap it in hashs (#) for insertion into Access.
Check out the DatePart function in VBScript. codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>
Then just remember to wrap it in hashs (#) for insertion into Access.
Check out the DatePart function in VBScript. codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>
- Thread starter
- #3
Ok, i'm not sure what you mean by the # around the date. the line i want to insert is something like this
reEmployee("Birthdate"
= Request.Form("Birthdate"
so how would i format the request.form("Birthdate" part to go into the database as a date?
Thanks for the reply.
reEmployee("Birthdate"
= Request.Form("Birthdate"so how would i format the request.form("Birthdate"
part to go into the database as a date?Thanks for the reply.
Ahh, you're using the old .update method.
Let's see - this should give you thew idea.
<%@enablesessionstate="false"%>
<html>
<head>
<title>QS to Date Test</title>
</head>
<body>
<script runat="server" language="vbscript">
if len(Request.QueryString("testdate") > 0 then
dim dt_Date
dim str_Months(11)
str_Months(0) = "Jan"
str_Months(1) = "Feb"
str_Months(2) = "Mar"
str_Months(3) = "Apr"
str_Months(4) = "May"
str_Months(5) = "Jun"
str_Months(6) = "Jul"
str_Months(7) = "Aug"
str_Months(8) = "Sep"
str_Months(9) = "Oct"
str_Months(10) = "Nov"
str_Months(11) = "Dec"
dt_Date = Request.QueryString("testdate"
Response.Write datepart("d", dt_Date) & "-" & str_Months(datepart("m", dt_Date)-1) & "-" & datepart("yyyy", dt_Date)
end if
</script>
</body>
</html>
(there's also the day, month and year f'ns in vbscript) codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>
Let's see - this should give you thew idea.
<%@enablesessionstate="false"%>
<html>
<head>
<title>QS to Date Test</title>
</head>
<body>
<script runat="server" language="vbscript">
if len(Request.QueryString("testdate"
) > 0 then dim dt_Date
dim str_Months(11)
str_Months(0) = "Jan"
str_Months(1) = "Feb"
str_Months(2) = "Mar"
str_Months(3) = "Apr"
str_Months(4) = "May"
str_Months(5) = "Jun"
str_Months(6) = "Jul"
str_Months(7) = "Aug"
str_Months(8) = "Sep"
str_Months(9) = "Oct"
str_Months(10) = "Nov"
str_Months(11) = "Dec"
dt_Date = Request.QueryString("testdate"
Response.Write datepart("d", dt_Date) & "-" & str_Months(datepart("m", dt_Date)-1) & "-" & datepart("yyyy", dt_Date)
end if
</script>
</body>
</html>
(there's also the day, month and year f'ns in vbscript) codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question