Date Function - ASP Forum - Computer Learning Zone


	Back to ASP Forum Comments List

Date Function

Diane Stankevitz

4 years ago

I am trying to filter my sql string to show only data that has been entered on the current date.

It works for a specific date:
SQL = "SELECT * FROM VisitorT WHERE VisitorStartDate='5/23/2022 12:53:12 PM' ORDER BY VisitorStartDate DESC "

But I want it for the current date. I keep getting an error when I write it like this:

SQL = "SELECT * FROM VisitorT WHERE VisitorStartDate= " & (Date()) & "ORDER BY VisitorStartDate DESC "

or a variety of other ways.

Can anyone help me with the correct line of code. :-)

	Kevin Robertson @Reply 4 years ago
You are missing a space between the Date function and the Order By clause. `SQL = "SELECT * FROM VisitorT WHERE VisitorStartDate=#" & Date() & "# ORDER BY VisitorStartDate DESC "`

	Scott Axton @Reply 4 years ago
One other little subtle thing as well. In SQL dates need to be surrounded by the # symbol so that Access knows to treat it as a date. Kevin included it in his response but didn't point it out.

	Richard Rost @Reply 4 years ago
Remember the # are for Access. If this is ASP on SQL Server then you need: `SQL = "SELECT * FROM VisitorT WHERE VisitorStartDate='" & Date() & "' ORDER BY VisitorStartDate DESC"` Yeah, I know... it gets me sometimes too.

	Richard Rost @Reply 4 years ago
And don't forget if the dates in your table have TIMES on them, then comparing to an exact date might not give you any records. :)

	Scott Axton @Reply 4 years ago
OOPS- I missed that this was in ASP TechHelp. Guess that's why you are the boss Richard.

	Diane Stankevitz OP @Reply 4 years ago
Thank you everyone. That help!!!!!

	Richard Rost @Reply 4 years ago
:)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in ASP Forum.

Next Unseen