I took a break from Allied Assault to try this when I saw your reply!
Again, IT WORKS. - don't understand why my way doesn't work but - whatever. I'll be copy/pasting that a lot. Thanks again, Shawn. --- In [email protected], "Shawn K. Hall" <[EMAIL PROTECTED]> wrote: > Hi Rick, > > > I'd like to count today's posts... > > Try this: > sql = "SELECT COUNT (*) FROM post " & _ > "WHERE postdate BETWEEN #" & Date() & "# " & _ > "AND #" & Date()+1 & "#;" > > Regards, > > Shawn K. Hall > http://12PointDesign.com/ > http://ReliableAnswers.com/ > > '// ======================================================== > "Of all tyrannies, a tyranny exercised for the good of > its victims may be the most oppressive." > -- C.S. Lewis --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
