I want to do update a table at the date datatype. The fieldname is tarikhmula
I retrieve a date from calendar and sent to the second page and this date become string.

I'm using this statement

sq = "update RekodCuti set jumcuti = '"&jum&"', tarikhmula = '"&tt&"' where idrekod = "&idrekod
set rs = db.execute(sq)

I get error message datatype mismatch and I find the error because I update tarikhmula with tt.

can somebody help me.

What format is tt in at this point?? is it dd/mm/yyyy or yyyymmdd or mm-dd-yyyy or what?

What format are your dates in the database? What sort of database are you using??

right after this line:
sq = "update RekodCuti set jumcuti = '"&jum&"', tarikhmula = '"&tt&"' where idrekod = "&idrekod

put this and post the results:
Response.Write sq