Select ...
where YEAR( DateField) = 2004 ;
and MONTH( DateField) = 12
>Can someone please help me, I have some records with date field type, what I want to ask is simple: how to filter those records by month and year .. (ie. I want to show sales records with the following criteria:
>
>date field is salesdate
>
>month = 12
>year = 2004
>
>please advise .. thanks a lot in advance
>
>Regards
>Winanjaya
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.