But it is useless to me since it is not in date format and when I want to filter the data for a period of time it doesn't work.
I need to convert it into a date format that Cognos can recognize, but when I try to convert it into a date format, it fails.