That is how get date works, its the current date and time of the server at the time you call it. However you can still select columns based on just the date here is what you have to do:
SELECT
column,
column,
column,
convert(varchar(10), datefield, 101) as [Createddt]
from table
where [clause]
That select statement will return you just the datepart of the datetime field then you can set the column value to a variable and then your createddt part of your where clause will just be:
Dim sDate
sDate = rs("createddt")
SELECT * from table where createddt = & sDate
hth
-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
^^Thats my signature
|