i want to select rows from the db table with month as the selection criteria .
the object is as follows :
parameter : date like sy-datum obligatory .
select * from tcurr into it where gdatu = date
here the date must fall within the month of the selection screen parameters.
ie if date = 26.12.2006, then the month is december and hence i have to retrieve all the rows from the table TCURR based upon the condition that the GDATU field must fall in the month of only december .
i have tried this but it didn't work out .
eg : select * from tcurr where gdatu = '12' .
can anybody can give me a hint .
thanx in advance .