Well to keep it simple....

As "SSCertifiable" said, All I had to do was convert the fields to "date" to get the same result.

Since I already had the data imported...

1st: I ran this query accordingly....

UPDATE table_name

SET column_name = REPLACE(REPLACE(column_name, '00:00:00', ''), '-', '')

Worked great, my ending result was the dates looked like...

Ok, awesome guys, I'll convert it to a date first then run these query's. Thanks a million. Will post results.

Thank you for such a quick reply. Yes, I can convert it to a date, actually in the new app, I had these columns setup as dates but I had...