twiog

OMGosh that did it!!! Thanks so much.

I imported the data from a CSV file which had the date field in that format. Once I update all of the dates to proper dates in the CreateDate field I will delete the CreateDateTxt field.

I'm using MySQL 5.5 I have a varchar 25 field called CreateDateTxt which is full of dates like this 3/15/2014 I have a date field called CreateDate which I would like to populate based on the CreateDateTxt field I can populate the CreateDate field successfully using this: UPDATE tblMembers SET CreateDate = '1975-12-07' But it doesn't give me the results I want using this: UPDATE tblMembers SET CreateDate = str_to_date(CreateDateTxt,'%d %m %Y') The query runs without errors but It populates the CreateDate field in all the records with this: 0000-00-00 Any help? Thanks!