DateAdd("d",20,now())...can´t find error

Results 1 to 2 of 2

Thread: DateAdd("d",20,now())...can´t find error

  1. #1
    na8ur Guest

    Default DateAdd("d",20,now())...can´t find error

    Hi..<BR>I work with access...my database has some cells wich are formated as date/time... like 25.06.99<BR><BR>now I use this:<BR>&#060;%<BR>dim myDate<BR>myDate=FormatDateTime((DateAdd("d",20,no w())),0)<BR>set rs=Server.CreateObject("ADODB.Recordset")<BR>rs.Op en "SELECT * FROM 3Sat WHERE Datum=myDate ORDER BY id asc","DSN=test.kunstmarkt.com"<BR>&#037;&#062;<BR > &#060;% dim i<BR> i=0<BR> while not rs.EOF and i&#060;13<BR> i=i+1<BR> &#037;&#062;<BR><BR>error message is not enough parameters<BR>but the rs -- works fine when I use Datum=date() [&#039if date() is the same date as in the cell.<BR><BR>thx<BR>

  2. #2
    gert Guest

    Default FormatDateTime((DateAdd("d",20,now())),2) still with error

    &#060;%<BR> dim myDate<BR> myDate=FormatDateTime((DateAdd("d",20,now())),2)<B R> set rs=Server.CreateObject("ADODB.Recordset")<BR> rs.Open "SELECT * FROM 3Sat WHERE Datum=myDate ORDER BY id<BR> asc","DSN=test.kunstmarkt.com"<BR> &#037;&#062;<BR> &#060;% dim i<BR> i=0<BR> while not rs.EOF and i&#060;13<BR> i=i+1<BR> &#037;&#062;<BR><BR>makes it better but still giving error back

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •