Classic ASP Discussion - date question

Print Page | Close Window

date question

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=4329
Printed Date: 30 March 2026 at 6:30am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: date question

Posted By: faubo
Subject: date question
Date Posted: 18 July 2003 at 11:30am

Hello,

I have a date field in an Access DB. I want to make a query for a month.

EX. date in the DB - 13/10/2003

I want to query "October"

How do I do that?

Thanks!

-------------
http://www.conhecerparaconservar.org - I don't know how to make you click here

Replies:

Posted By: michael
Date Posted: 18 July 2003 at 11:46am

strSQL = "SELECT * FROM ttable WHERE DatePart(""m"",[tdate])=10"

10 for October

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: faubo
Date Posted: 18 July 2003 at 1:55pm

Thanks! I will try it!

I was expecting a much more complicated way!

-------------
http://www.conhecerparaconservar.org - I don't know how to make you click here