Thread: Text to Date
View Single Post
Old 02-09-2018, 09:48 PM   #5
ilovejedd
hopeless n00b
ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.
 
ilovejedd's Avatar
 
Posts: 5,110
Karma: 19597086
Join Date: Jan 2009
Location: in the middle of nowhere
Device: PW4, PW3, Libra H2O, iPad 10.5, iPad 11, iPad 12.9
The last_modified date changed but to Feb 09, 2018 (today), not to the one specified in the replacement regex (and I did try several variations).

After several failed trials, I eventually created a custom column #modified with format yyyy-MM-dd and it worked there. Mayhaps last_modified is a special column or something that can't simply be edited by the user?

Curious, though, will a datetime column accept yyyy-mm-dd regardless of the display format (e.g. MMM d, yyyy)? Thanks!

Last edited by ilovejedd; 02-09-2018 at 09:52 PM.
ilovejedd is offline   Reply With Quote