Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filter by month and year
Message
From
05/01/2005 19:01:26
Luis Guerra
Lima, Peru
 
 
To
05/01/2005 09:53:40
Winan Jaya
Jakarta, Indonesia
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Filter by month and year
Miscellaneous
Thread ID:
00974373
Message ID:
00974563
Views:
18
Yes Winan, the syntax is correct. It will work with both, SQL Server and VFP.

Luis



>I mean in SQL syntax? ..
>SELECT * FROM SALES WHERE MONTH(DATEFIELD) = 12 AND YEAR(DATEFIELD) = 2004 .. am I correct? .. please advise
>
>TIA
>Winanjaya
Luis Guerra
lguerra3@gmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform