CodingForums.com - View Single Post

Cipher · 09-21-2005, 11:55 PM

i'm having a web forum and i wanna make a page to show all Today's Posts, and i'm using MS SQLServer 2000, so i tried to do this in the SQL Statment:

Where Posts.DatePosted Between #09/20/2005# AND #09/22/2005#

But it appeared this error:

Incorrect syntax near '#'.

So can any body tell me a good way to do this.

09-21-2005, 11:55 PM	PM User \| #1
Cipher Regular Coder Join Date: Dec 2004 Posts: 123 Thanks: 0 Thanked 0 Times in 0 Posts	SQL DateTime Problem i'm having a web forum and i wanna make a page to show all Today's Posts, and i'm using MS SQLServer 2000, so i tried to do this in the SQL Statment: Where Posts.DatePosted Between #09/20/2005# AND #09/22/2005# But it appeared this error: Incorrect syntax near '#'. So can any body tell me a good way to do this.