To add date in mysql database

Hi ,
I have an asp page which is used to add a record to the database.When adding it to the database it shud add the date of the day without entering it.

I could achieve this in MSAccess but im not able to do it in mysql.In MSAccess i just add the Now() function.

This is My ASP code:-

<%
dim oCn,oRs,connstr,userid,clientid
dim RsActName,sqlActName,StrActName
dim cid,dateAdded



set oRs=server.CreateObject("adodb.recordset")

activityId = request.QueryString("activityId")

connstr = DSN
Set oCn = gf_OpenConnection(connstr)

set RsActName=server.CreateObject("adodb.recordset")
set RsdisName=server.CreateObject("adodb.recordset")

if activityid<>"" then

sqlActName="select * from activitytb where activityid="&activityid&""
RsActName.Open sqlActName,oCn,3,1

if not RsActName.EOF then
StrActName=RsActName("activityname")
cid=RsActName("clientid")
end if

end if

if cid<>"" then

SqlDisName="select * from itclienttb where listid="&cid&""
RsdisName.Open SqlDisName,oCn,3,1

if not RsdisName.EOF then

if RsdisName("clientfirstname")<>"" or RsdisName("clientlastname")<>"" then
StrValue = RsdisName("clientfirstname")
else
StrValue=RsdisName("companyname")
end if
end if

end if



if request("taskDescription")<>"" then

chksql="select * from tasktb where taskDescription='"&request("taskDescription")&"' and activityid="&request("hidactivityid")&" "
oRs.Open chksql,oCn,3,1


if not oRs.Eof then %>

<% response.write "<center class=""navlink""><b>Not a Valid Record</b></center>"



else


SQl="insert into tasktb(activityId,agentid,taskDescription,dateAdde d)values("&request("hidactivityid")&","&session("userid")&",'"&request("taskDescription")&"','"&Date&"')"
oCn.Execute SQL

Response.Write "<center class=""navlink"" >Record has been successfully inseted</center>"
%>

<script language='javascript'>
opener.location.reload()
</script>
<br>
<center><a href='javascript:window.close()' class="navlink" >close</a></center>

<%end if



Can anyone help me to resolve this...

Regards,
JaiShankar...

If the field in the database is a date field, then you can use the constant CURRENT_DATE, if it is a date time field then you can use the NOW() function and it should work.