sir <BR> here i am trying to replace existing dates in datbase with dates staring from yesterday&#039;s date of the current date and the this action should be saved in database <BR> eg: if current date is 03/11/2001 then yesterdays date : 02/11/2001<BR><BR>&#060;!-- #include virtual = "/" --&#062;<BR>&#060;%<BR>str = "select scorpio from horo"<BR>set con=Server.CreateObject("adodb.connection")<BR>con .Open"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:amitwataniyahorohoro.mdb;Persist Security Info=False"<BR>set rs = Server.CreateObject("adodb.recordset")<BR>set rs1 = Server.CreateObject("adodb.recordset")<BR>rs.Open str,con,adOpenStatic<BR>Response.Write "page updated"<BR> for i = 0 to rs.recordcount<BR> aa = (date - 1) + i<BR> Response.Write aa &"<BR>"<BR> str1 = "update horo set hdate=&#039;" &aa &"&#039;"<BR> rs1.Open str1,con<BR> next<BR><BR>%&#062;<BR><BR>can u please rectify as what is wrong in this