[thelist] ASP Date Manipulation

[Paul Backhouse]

have you checked that your date field in your database is Date/time?
What format are you adding the date into the database in?

cheers

paul

-----Original Message-----
Here is my code:

pastdate = DateAdd("m",-3,Now())  'pastdate is now three months ago

do while not rs.eof
    if rs("date_completed") > pastdate then  'if date in database is newer
than date three months ago
        response.write pastdate  'show the date
    end if
loop

I tried using both 2/01/02 and 2/01/02 in the database and neither makes the
date show.

Anyone know where I am wrong?

Thanks,
Josh