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:
convert(varchar(10), datefield, 101) as [Createddt]
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:
sDate = rs("createddt")
SELECT * from table where createddt = & sDate
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