numbenator
24 Aug 2005, 10: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
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