>Our last programmer created this free table, and the date information that was inputted is located in a character field. Therefore when try to set a filter it filters the data on the first couple of characters. I have tried LEFT, RIGHT, SUBSTR, but have no luck. Can anyone help me in trying to figure a way to filter this table by date. This table has over 20,000 records. Thanks!
Lea,
But you don't give a clue how the date format is. You could do a conversion to date format. ie: say current format is MMDDYYYY. :
alter table myTable add column Newdate d
replace all NewDate with ;
date(val(substr(Old,5,4)),val(substr(Old,1,2)),val(substr(Old,3,2)))
PS:Some formats are compatible with directly setting new field type to date.
Cetin