ASP Guru needed PLEEEZ
- Started
- Last post
- 4 Responses
- 187LockDown
OK I got this ASP page that is suppose to list out events Morethan or equal to Todays date and Less than or equal to the last day of this month. In other words It should only list out events (Dates) For the current month and not any past dates.
http://www.theclub-online.com/cl…
I lefet the SQL at the top so you can see what iM DOING
- 187LockDown0
Here is what my SQL looks like before the ASP engine gets done with it:
SELECT * FROM Dates WHERE DateDate >= "&FormatDateTime(Date())&" AND DateDate <= "&FormatDateTime(DateSerial(Year... ORDER BY DateDate ASC
- 187LockDown0
Can anyone help? I think SQL is not able to recognize that it is a date???
- jarmstrong0
does the DateDate field have datetime data type?
- 187LockDown0
Yes it sure does. I also tried using getDate() instead of date in the SQL but that didn't work either which was very odd because I did that on another site of mine and it worked perfect. I used if
DateDate >= getDate() I have tried everything. I really need a good resource on how to filter recordsets using the date object and comparing it to Access Date/Time Fields.