Help with Comparing Dates

[Carl_FK]

Hi Everyone,

This is my first post, so wohey!

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.

[Bullschmidt]

Hi Carl!

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

[glenngv]

DateDiff

[Carl_FK]

Thanks for the fast response guys!

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

[Carl_FK]

Hi Guys

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

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]

Originally Posted by Carl_FK

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) %>

[Bullschmidt]

Originally Posted by Carl_FK

Hi Guys

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

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.

[fractalvibes]

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