{"id":1107,"date":"2016-12-14T09:50:53","date_gmt":"2016-12-14T09:50:53","guid":{"rendered":"http:\/\/docs.contentviewspro.com\/?p=1107"},"modified":"2025-08-21T08:26:50","modified_gmt":"2025-08-21T08:26:50","password":"","slug":"specify-date-format-for-sorting-custom-field","status":"publish","type":"docs","link":"https:\/\/contentviewspro.com\/documentation\/article\/specify-date-format-for-sorting-custom-field\/","title":{"rendered":"Set MySQL date format when sort by a custom field"},"content":{"rendered":"

If the value (stored in database) of your date custom field is not in kind of Year Month Day<\/strong> format (for example: 1970-01-01 or 1970\/01\/01), WordPress may not able to sort by that field correctly.<\/p>\n

To make it work correctly, please specify MySQL date format of the value (stored in database) of your custom field.<\/p>\n

Here are some common formats:
\n%m\/%d\/%Y<\/code> (for m\/d\/Y)
\n%m-%d-%Y<\/code> (for m-d-Y)
\n%d\/%m\/%Y<\/code> (for d\/m\/Y)
\n%d-%m-%Y<\/code> (for d-m-Y)<\/p>\n

Here are some examples:
\ndate value is Jan 01 1970<\/strong> => date format is %b %d %Y<\/code>
\ndate value is 1st\/01\/1970<\/strong> => date format is %D\/%m\/%Y<\/code>
\ndate value is 2020-10-20<\/strong> => date format is %Y-%m-%d<\/code>
\ndate value is 1543310966<\/strong> => date format is _UNIX_TIMESTAMP_<\/code> (this custom format is available since Content Views Pro version 5.4.0)<\/p>\n

Please check below table to get correct format for each part in your date value.<\/p>\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Value<\/th>\nFormat<\/th>\n<\/tr>\n<\/thead>\n
Unix timestamp ( a long number string, for example: 1543310966 )<\/td>\n_UNIX_TIMESTAMP_<\/code><\/td>\n<\/tr>\n
Abbreviated weekday name ( Sun<\/code>.. Sat<\/code>)<\/td>\n%a<\/code><\/td>\n<\/tr>\n
Abbreviated month name ( Jan<\/code>.. Dec<\/code>)<\/td>\n%b<\/code><\/td>\n<\/tr>\n
Month, numeric ( 0<\/code>.. 12<\/code>)<\/td>\n%c<\/code><\/td>\n<\/tr>\n
Day of the month with English suffix ( 0th<\/code>, 1st<\/code>, 2nd<\/code>, 3rd<\/code>, \u2026)<\/td>\n%D<\/code><\/td>\n<\/tr>\n
Day of the month, numeric ( 00<\/code>.. 31<\/code>)<\/td>\n%d<\/code><\/td>\n<\/tr>\n
Day of the month, numeric ( 0<\/code>.. 31<\/code>)<\/td>\n%e<\/code><\/td>\n<\/tr>\n
Microseconds ( 000000<\/code>.. 999999<\/code>)<\/td>\n%f<\/code><\/td>\n<\/tr>\n
Hour ( 00<\/code>.. 23<\/code>)<\/td>\n%H<\/code><\/td>\n<\/tr>\n
Hour ( 01<\/code>.. 12<\/code>)<\/td>\n%h<\/code><\/td>\n<\/tr>\n
Hour ( 01<\/code>.. 12<\/code>)<\/td>\n%I<\/code><\/td>\n<\/tr>\n
Minutes, numeric ( 00<\/code>.. 59<\/code>)<\/td>\n%i<\/code><\/td>\n<\/tr>\n
Day of year ( 001<\/code>.. 366<\/code>)<\/td>\n%j<\/code><\/td>\n<\/tr>\n
Hour ( 0<\/code>.. 23<\/code>)<\/td>\n%k<\/code><\/td>\n<\/tr>\n
Hour ( 1<\/code>.. 12<\/code>)<\/td>\n%l<\/code><\/td>\n<\/tr>\n
Month name ( January<\/code>.. December<\/code>)<\/td>\n%M<\/code><\/td>\n<\/tr>\n
Month, numeric ( 00<\/code>.. 12<\/code>)<\/td>\n%m<\/code><\/td>\n<\/tr>\n
AM<\/code> or PM<\/code><\/td>\n%p<\/code><\/td>\n<\/tr>\n
Time, 12-hour ( hh:mm:ss<\/code> followed by AM<\/code> or PM<\/code>)<\/td>\n%r<\/code><\/td>\n<\/tr>\n
Seconds ( 00<\/code>.. 59<\/code>)<\/td>\n%S<\/code><\/td>\n<\/tr>\n
Seconds ( 00<\/code>.. 59<\/code>)<\/td>\n%s<\/code><\/td>\n<\/tr>\n
Time, 24-hour ( hh:mm:ss<\/code>)<\/td>\n%T<\/code><\/td>\n<\/tr>\n
Week ( 00<\/code>.. 53<\/code>), where Sunday is the first day of the week; WEEK()<\/code> mode 0<\/td>\n%U<\/code><\/td>\n<\/tr>\n
Week ( 00<\/code>.. 53<\/code>), where Monday is the first day of the week; WEEK()<\/code> mode 1<\/td>\n%u<\/code><\/td>\n<\/tr>\n
Week ( 01<\/code>.. 53<\/code>), where Sunday is the first day of the week; WEEK()<\/code> mode 2; used with %X<\/code><\/td>\n%V<\/code><\/td>\n<\/tr>\n
Week ( 01<\/code>.. 53<\/code>), where Monday is the first day of the week; WEEK()<\/code> mode 3; used with %x<\/code><\/td>\n%v<\/code><\/td>\n<\/tr>\n
Weekday name ( Sunday<\/code>.. Saturday<\/code>)<\/td>\n%W<\/code><\/td>\n<\/tr>\n
Day of the week ( 0<\/code>=Sunday.. 6<\/code>=Saturday)<\/td>\n%w<\/code><\/td>\n<\/tr>\n
Year for the week where Sunday is the first day of the week, numeric, four digits; used with %V<\/code><\/td>\n%X<\/code><\/td>\n<\/tr>\n
Year for the week, where Monday is the first day of the week, numeric, four digits; used with %v<\/code><\/td>\n%x<\/code><\/td>\n<\/tr>\n
Year, numeric, four digits<\/td>\n%Y<\/code><\/td>\n<\/tr>\n
Year, numeric (two digits)<\/td>\n%y<\/code><\/td>\n<\/tr>\n
A literal %<\/code> character<\/td>\n%%<\/code><\/td>\n<\/tr>\n
x<\/code><\/em>, for any \u201c x<\/code><\/em><\/span>\u201d<\/span> not listed above<\/td>\n% x<\/code><\/em>
\n<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Source: https:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/date-and-time-functions.html#function_date-format<\/p>\n","protected":false},"excerpt":{"rendered":"

If the value (stored in database) of your date custom field is not in kind of Year Month Day format (for example: 1970-01-01 or 1970\/01\/01), WordPress may not able to sort by that field correctly. To make it work correctly, please specify MySQL date format of the value (stored in database) of your custom field. …<\/p>\n

Set MySQL date format when sort by a custom field<\/span> Read More »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"doc_category":[52],"doc_tag":[13,28],"class_list":["post-1107","docs","type-docs","status-publish","hentry","doc_category-custom-field","doc_tag-custom-field","doc_tag-sort"],"year_month":"2026-09","word_count":402,"total_views":"1","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"admin1","author_nicename":"admin1","author_url":"https:\/\/contentviewspro.com\/documentation\/author\/admin1\/"},"doc_category_info":[{"term_name":"Custom Field (core, ACF, Metabox, etc.)","term_url":"https:\/\/contentviewspro.com\/documentation\/cats\/custom-field\/"}],"doc_tag_info":[{"term_name":"custom field","term_url":"https:\/\/contentviewspro.com\/documentation\/tags\/custom-field\/"},{"term_name":"sort","term_url":"https:\/\/contentviewspro.com\/documentation\/tags\/sort\/"}],"_links":{"self":[{"href":"https:\/\/contentviewspro.com\/documentation\/wp-json\/wp\/v2\/docs\/1107","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/contentviewspro.com\/documentation\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/contentviewspro.com\/documentation\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/contentviewspro.com\/documentation\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/contentviewspro.com\/documentation\/wp-json\/wp\/v2\/comments?post=1107"}],"version-history":[{"count":6,"href":"https:\/\/contentviewspro.com\/documentation\/wp-json\/wp\/v2\/docs\/1107\/revisions"}],"predecessor-version":[{"id":6148,"href":"https:\/\/contentviewspro.com\/documentation\/wp-json\/wp\/v2\/docs\/1107\/revisions\/6148"}],"wp:attachment":[{"href":"https:\/\/contentviewspro.com\/documentation\/wp-json\/wp\/v2\/media?parent=1107"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/contentviewspro.com\/documentation\/wp-json\/wp\/v2\/doc_category?post=1107"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/contentviewspro.com\/documentation\/wp-json\/wp\/v2\/doc_tag?post=1107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}