DateAdd does not work

[lofty]

Dear Lord,

I'm trying to code a drop down for a date entry that gives
the user the option of the current date plus the dates of
the last 7 days.

<%
for i = -7 to -1
Response.write "<option>" & DateAdd(d,i,Date())
& "<option>"
next
%>
Besides this, even the following code generates an error:

Today=Date()
Response.write DateAdd(d,5,Today)

your guidence is sought, oh great one.
amen

 

[Chris Barber]

For i = 0 to -7 Step -1
If i = 0 Then
pstrSelected = " selected"
Else
pstrSelected = vbNullString
End If
Response.write "<option" & pstrSelected & " value=""" & CDate(Date() +
i) & """>" & FormatDateTime(Date() + i, 1) & "<option>"
Next

NB: vbLongDate = 1

See:
http://msdn.microsoft.com/library/d...y/en-us/script56/html/vsfctFormatDateTime.asp

Chris.

 

[lofty]

Thankyou,

but could u tell me why i'm getting the error

Microsoft VBScript runtime (0x800A0005)
Invalid procedure call or argument: 'DateAdd'

when i,m using dateAdd

 

[Mosley]

Dear Lord,

I'm trying to code a drop down for a date entry that gives
the user the option of the current date plus the dates of
the last 7 days.


aharrrrrrr


NO
DateAdd(d,i,Date())

Yes
DateAdd("d",i,Date())




<%
for i = -7 to -1
Response.write "<option>" & DateAdd(d,i,Date())
& "<option>"
next
%>
Besides this, even the following code generates an error:

Today=Date()
Response.write DateAdd(d,5,Today)

your guidence is sought, oh great one.
amen

 

[Bob Barrows]

Dear Lord,

I'm trying to code a drop down for a date entry that gives
the user the option of the current date plus the dates of
the last 7 days.

<%
for i = -7 to -1
Response.write "<option>" & DateAdd(d,i,Date())
& "<option>"
next
%>
Besides this, even the following code generates an error:

Today=Date()
Response.write DateAdd(d,5,Today)

your guidence is sought, oh great one.
amen

I'm not a lord; however:
in vbscript, the first argument needs to be quoted since it must be a
string:
DateAdd("d",i,Date())

If you do not have the vbscript reference, it can be downloaded from here:
http://tinyurl.com/7rk6

HTH,
Bob Barrows

 

[Chris Barber]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vsfctDateAdd.asp

First parameter must be a string value (eg. "d"), not a variable reference
(eg. d).

Chris.