Select -option Date field in MM/YYYY format!
Iam having DATE field as selection screen SELECT_OPTION parameter.
And I am fetching records from one of my tables with where condition of this select-option.
Now my reuirement is to modify that DATE select-option with 7 characters i.e. MM/YYYY
So if user enters 09/2008 as DATE-LOW.. I have to fetch all records of September 2008.
If user enters 09/2008(lower limit) and 02/2009(Upper limit)...
I have to fetch records between... September 1st 2008 to 28th february 2009.
What is the simplest way to impliment this?