SQL/ASP.NET getting DATE to work in query

[darrel]

I'm grabbing today's date with some ASP.net code:

Dim Today As Date
Today = Microsoft.VisualBasic.Today()

I'm then trying to run a SQL query with the following WHERE statement:

WHERE postdate <= " & Today & "

But it's pulling up records that have a postdate in the future.

A sample:

Today (when written to screen) = 3/23/2005 12:00:00 AM
In the SQL table postdate field = 3/28/2005

Anyone see something wrong with what I have that would be causing this? Is
it because in my code I'm grabbing the time, while SQL is only storing the
date?

-Darrel

[Julian Roberts]

Use the datediff() function. eg

where datediff('d',myfield,date())<=0

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[darrel]

> Use the datediff() function. eg
>
> where datediff('d',myfield,date())<=0

So, that's the difference between my date in the database and todays date in
days? How is the day measured? Ie, is that the number of days since 1900 (or
whatever the default date is in SQL?

-Darrel

[darrel]

> Use the datediff() function. eg

>
> where datediff('d',myfield,date())<=0

Hmm...well, I tried this:

datediff('d',pulldate,date()) <= 0

and got this:

'date' is not a recognized function name.

-Darrel