Reply To: Time sorting for time picker field not working regardless of format

• elba

• September 27, 2014 at 6:44 am

Hi Elliot,

For some reason I set the save format as: YY_mm_dd a long time ago, and now I need to sort posts by that value.
I’m afraid that if I simply change the save format to yymmdd now, I’ll lost 100+ posts’ date value…
What would you advise? Should I change the save format and then correct the dates already stored in the database somehow? They are saved as: 2011_06_23.

Thanks,
elba