Help with S/R from text column to a date column

[belton180]

Originally Posted by theducks

The marks only apply to True/False (includes the Tri-state: undefind = blank)

If you have already populated the TEXT column, it gets tricky to recover, but very doable using the Search and replace feature in Bulk Metadata edit.
(ask for instructions, telling us the EXACT values (includes Case) that exist. )

Sorry for the necro, but I'm having a problem with the search and replace, I used regular expression search to copy information from a text column to a date column, however it copies the wrong info, example, the information is 2013-03-01 15:49:21, yyyy-mm-dd hh:mm:ss, however the data that gets input into the date column is 2013-49-01.

Thanks

[DoctorOhh]

Moderator Notice
Post moved to its own thread

Welcome to Mobileread.

Originally Posted by belton180

Sorry for the necro

Then don't do it. The previous old thread barely had anything in common with what you want to do. Hopefully more folks will see this new thread and lend a hand.

Good Luck

[chaley]

Originally Posted by belton180

Sorry for the necro, but I'm having a problem with the search and replace, I used regular expression search to copy information from a text column to a date column, however it copies the wrong info, example, the information is 2013-03-01 15:49:21, yyyy-mm-dd hh:mm:ss, however the data that gets input into the date column is 2013-49-01.

Thanks

Use MM (month) instead of mm (minutes) in the date portion of the pattern.