Re-Envisioned › Support › MB Custom Table › Date format between custom field and database field › Reply To: Date format between custom field and database field
ok perfect, I will use option 2:
array ( 'id' => 'fecha_inicio_evento', 'type' => 'date', 'name' => 'Fecha Inicio', 'js_options' => array( 'dateFormat' => "dd/mm/yy", ), 'save_format' => 'Y-m-d', 'timestamp' => false, ),
Also, in docs: https://docs.metabox.io/fields/date/
“Saving in timestamp also allows you to query posts with a specific order by this field”.
I try to put timestamp to true. I tried to change the field of database from ‘fecha_inicio_evento’ => ‘DATE’, to ‘fecha_inicio_evento’ => ‘TIMESTAMP’, and I can not make it work…
I docs it says “However, you still can sort posts by meta value if you set date format to something similar to yy-mm-dd.”.
With my settings, could I sort by date?