Help with Comparing Dates

Hi Everyone,

This is my first post, so wohey! :D

Anyway, to the point, I would like some help on comparing dates.
Basically, I have a date (dd/mm/yy) in my SQL database, which I can connect to, and output onto a page. I need to compare the date in my database, with todays date.
And, if todays date is after (or equal to) the date in the database, it outputs a string of text.

Sounds quite simple... although I'm not sure how to do this.
P.S. I'm quite experienced with ASP although never tried this. :)

Thanks,

Carl.

Hi Carl!

If objRS("TheDateField") <= Date() Then
...
End If

DateDiff (http://www.devguru.com/Technologies/vbscript/quickref/datediff.html)

Thanks for the fast response guys!

I will try them out tonight and let you know how I got on. :)

Hi Guys

Bullschmidt, unfortunately yours didnt seem to do anything... There were no errors, but it didnt return a string :confused:

glenngv, i had a look at yours, but it doesnt seem like what I want (correct me if i'm wrong), but do you recon you could give an example.

Any other ideas?

Thanks guys

glenngv, i had a look at yours, but it doesnt seem like what I want (correct me if i'm wrong), but do you recon you could give an example.

The link that I posted already gives you examples.

<%=DateDiff("d", Date, "1/1/2000") %>

<% olddate = #6/26/43# %>
<% nowdate = Now %>
<% =DateDiff("S", nowdate, olddate) %>

Hi Guys

Bullschmidt, unfortunately yours didnt seem to do anything... There were no errors, but it didnt return a string :confused:


Well the only other thing I can think of is to make sure that the field in question in the database table really is a date/time field.

In SQL:

select col1
,col2
etc.
(CASE WHEN DateField <= CURRENT DATE THEN
'Yep'
Else
'Nope'
End) AS DoPrint
from your table
where .....

in code:
If rs("DoPrint") = "yep" then
'go ahead and output your string of text
End if