Thread: Help with S/R from text column to a date column
View Single Post
Old 04-02-2014, 05:23 AM   #3
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,465
Karma: 8025600
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by belton180 View Post
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.
chaley is offline   Reply With Quote