Need query............. [modified]
-
i have two month records in my table........, example: table look like this: id date remarks 1 02/28/2006 test1 2 02/24/2006 test2 3 03/31/2006 test3 4 03/12/2006 test4 5 03/12/2007 test5 if i tell month on "3" and year on "2006" then it want to display..., id=3 & 4 only..............., how to do this one......, plz hlp me...... Regards, Magesh,
Magi
-
i have two month records in my table........, example: table look like this: id date remarks 1 02/28/2006 test1 2 02/24/2006 test2 3 03/31/2006 test3 4 03/12/2006 test4 5 03/12/2007 test5 if i tell month on "3" and year on "2006" then it want to display..., id=3 & 4 only..............., how to do this one......, plz hlp me...... Regards, Magesh,
Magi
Hi You can filter using Month() and Year() functions. For example: Month(DateColumn) = 3 and Year(DateColumn) = 2006
Harini
-
Hi You can filter using Month() and Year() functions. For example: Month(DateColumn) = 3 and Year(DateColumn) = 2006
Harini
-
DooDooo wrote:
Can I have your email pls ?
No, you may not have my email. ;P