I am going to try an dmake this as clear as I can but I may end up being very vague.
The MsSQL database(needs to be used because of another program that updates it) has a column that is a date column. I can query it and pull date and even use a substr function to chop it down to display what I need. What I am hoping for is if someone knows of a way to interrupt the info as a DATE not just a series of numbers. I want to be able to use this to display info and I need to use this column to pull the newest info.
I am using the ODBC functions and I know there are functions for MySQL that would allow this. Anyone have an idea?