I want to enter today's date when an application form is approved/rejected. I am setting this in a hidden textbox in my form.
when the send this information to the database, I get the following error:
Type mismatch: 'FormatDateTime'

Here is the relevant code that I use when updating to the database:
Dim date, today
date = request.form("hdnDate")
today = FormatDateTime(date, vbLongDate)

sql = "UPDATE MEMBER SET APP_STATUS = '" & varAccess & "', NEW_APPLICATION = '" & varNewApp & "', TODAYS_DATE = '" & today & "', COMMENTS = '" & comm & "' WHERE MEMBER_ID = " & varMemberID & ""

the data type of the field in the database is Date/Time.

Please help.........

<tr>
<td><input type="hidden" name="hdnDate" value="<%= Now() %>">
</td>
</tr>

Actually, you do not need a hidden type. When you execute your SQL statement, you just put Now().

sql = "UPDATE MEMBER SET APP_STATUS = '" & varAccess & "', NEW_APPLICATION = '" & varNewApp & "', TODAYS_DATE = '" & Now() & "', COMMENTS = '" & comm & "' WHERE MEMBER_ID = " & varMemberID

And of course Date() is like Now() but without the time part.