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/
 



Reply via email to