Using cdate function in dreamweaver

Salims · January 17th, 2008, 07:28 AM

Hi,
I'm having problem with this code
<%
dim dob
dob=cdate(request.form("staffdd")+"/"+request.form("staffmonth")+"/"+request.form("staffyear"))
%>

I'm trying to append the values selected in my dropdown menus called: staffdd (for day on the day dropdown list), staffmonth(form month on the month dropdown list) and staffyear (for year on the year dropdown list).
I am using dreamweaver 8 and it is giving me: type mismatch error "cdate". Please how do i go about solving this error so it can display the date and insert it into a database.

aspless · January 17th, 2008, 09:21 AM

Salims

I may be misunderstanding your function but try below

Code:

<%
dim dob,staffdd,staffmonth,staffyear

staffdd = request.form("staffdd")
staffmonth = request.form("staffmonth")
staffyear = request.form("staffyear")

dob=cdate( & staffdd & "/" & staffmonth & "/" & staffyear )
%>

Hope this helps

Aspless

mat41 · January 17th, 2008, 06:42 PM

Firsty you should look up VBScript operators. You are using the addition operator (+) when you should be using the concatenation operator (&)

You are getting this error because one or more of the three values inside your cDate function is not valid. to show an example of this. Run this code:

<%
dim dob,d,m,y
d = "277"
m = "10"
y = "1972"

dob=cdate(d & "/" & m & "/" & y)
response.write dob
%>

This will give you the same error because one of your values is not valid. The 'd' variable requires a value less than the total number of days possible in the given month. Now chnage the 'd' value from '277' to '27' and run the code, it will now work.

So to fix your issue validate the form variables before they are submitted to ensure they will always be valid.

TIP - Use the IsDate function to determine if date can be converted to a date or time

Wind is your friend
Matt
www.elitemarquees.com.au