todays date greater than a Date?????

[mdang]

Hi EVeryone,

I am trying to compare a DATE from a database that is DateTime format
------------------------------
dDate = FormatDateTime(day(rs("eventdate&quot) & "/" & month(rs("eventdate&quot) & "/" & year(rs("eventdate&quot),2)
---------------------------------

comparing with a DATE like this
-------------------------------------
baseDate1 = FormatDateTime(date(),2)
--------------------------------

Then use an IF Statement like this it doesn't work?????
------------------------------------
if (dDate = baseDate1)then



WHY WHY??????????

 

[Bastien]

change date() to now()

baseDate1 = FormatDateTime(now(),2)

also try response.wrting the dates to the browser to ensure that they are there...

hth Bastien

There are many ways to skin this cat,
but it still tastes like chicken