PDA

View Full Version : SQL selection against month of a date field



numbenator
24 Aug 2005, 09:24 AM
Hi ,

Can I do the below?

strSQL = "SELECT * FROM comments where portal='"&portalName&"' and Month(entryDate)="&Cint(sMonth)


entryDate is a date field in the table
sMonth is a passed variable of value 1-12

If not, How do I in the selection of records reference the month part of a date field.

Cheers.

Steve