Database Discussion - Help pulling data in current month only

Print Page | Close Window

Help pulling data in current month only

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=9213
Printed Date: 28 March 2026 at 4:07am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Help pulling data in current month only

Posted By: Agent001
Subject: Help pulling data in current month only
Date Posted: 24 January 2004 at 8:28pm

I could use some help. I've been developing flat sites for some time now and am venturing into databases. I'm getting stuck trying to pull results out of a database where I only want the current months events to display.

Please help :)

Here is my current query
sql = "select * from tEvents ORDER BY (Start_Date) DESC"

It works beautifully however it displays all records in the database. I've tried several WHERE statements and just can't form the string correctly.

Thank You,

-------------
Agent001
Undercover Computers
www.undercovercomputers.com