var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query Criteria for Several Date Fields
I have three date fields with short date format.
What would be the sql statement if I wanted the result of any of the date fields containing a certain month be returned.
ID Date1 Date2 Date3
1 01/15/04 02/01/04 01/06/04
2 02/18/04 01/26/04 02/03/04
3 01/15/04 01/26/04 01/01/04
My prompt would say [Enter Month], so I enter 02.
I would like it to return Rows 1 and 2, since a least one of those three date fields does have a date that begins with 02.
Thanks in advance for the help!
select * from yourtable
where [Enter Month]
Thanks for the syntax. Worked perfectly