date problem

**todd2006** · todd2006, March 10th, 2010 02:22 PM

hello,

Code:

datetoday=Date()

sdate=rs("Startdate")
edate=rs("EndDate")

What I want to do is if datetoday is between the sdate and edate then set a variable

here is the code

Code:

If datetoday >= sdate and datetoday <= edate then
	setflag="1"
else
	setflag="2"
End if

but its saying setflag="2"

in the table the value of sdate="1/2/2010" and edate="4/11/2010"

any idea what i am doing wrong

todd

**jmurrayhead** · jmurrayhead, March 10th, 2010 02:36 PM

What is the output of:

Code:

Response.Write(datetoday & "<br />")
Response.Write(sdate & "<br />")
Response.Write(edaate & "<br />")

**todd2006** · todd2006, March 10th, 2010 02:41 PM

datetoday:3/10/2010
sdate:1/2/2010
edate:4/11/2010

**todd2006** · todd2006, March 10th, 2010 02:43 PM

startdate and enddate fields datatype is datetime in the database

**jmurrayhead** · jmurrayhead, March 10th, 2010 02:59 PM

Try:

Code:

If DateDiff("d", sdate, datetoday) >= 0 And DateDiff("d", edate, datetoday) <= 0 Then
    setflag = 1
Else
    setflag = 2
End If

Thread: date problem