{"id":1552,"date":"2019-01-28T13:38:52","date_gmt":"2019-01-28T19:38:52","guid":{"rendered":"https:\/\/wpsheeteditor.com\/es\/?post_type=snippets&#038;p=1552"},"modified":"2019-07-01T21:20:45","modified_gmt":"2019-07-02T03:20:45","slug":"formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa","status":"publish","type":"snippets","link":"https:\/\/wpsheeteditor.com\/es\/snippets\/formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa\/","title":{"rendered":"Formato de Celda: Mostrar el Valor de la Marca de Tiempo como Fecha Amistosa"},"content":{"rendered":"<p>Por ejemplo, nuestros mensajes tienen un campo meta con una marca de tiempo y la hoja de c\u00e1lculo muestra la marca de tiempo as\u00ed:<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2019\/01\/26205502\/2-2.png\" alt=\"\" width=\"609\" height=\"333\" class=\"aligncenter size-full wp-image-1554\" srcset=\"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2019\/01\/26205502\/2-2.png 609w, https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2019\/01\/26205502\/2-2-300x164.png 300w\" sizes=\"(max-width: 609px) 100vw, 609px\" \/><\/p>\n<p>Podemos usar el siguiente c\u00f3digo para mostrar los valores como fechas amistosas, para que podamos ver, editar y guardar la columna usando fechas amistosas:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"php\">add_filter('vg_sheet_editor\/provider\/post\/update_item_meta', 'wpse_expiration_filter_cell_data_for_saving', 10, 3);\r\nadd_filter('vg_sheet_editor\/provider\/post\/get_item_meta', 'wpse_expiration_filter_cell_data_for_readings', 10, 5);\r\n  \r\nfunction wpse_expiration_filter_cell_data_for_readings($value, $id, $key, $single, $context) {\r\n  if ($context !== 'read' || $key !== '_expiration-date' || ! $value) {\r\n    return $value;\r\n  }\r\n  \r\n  $value = get_date_from_gmt(gmdate('Y-m-d H:i:s', $value ));\r\n  return $value;\r\n}\r\n\r\nfunction wpse_expiration_filter_cell_data_for_saving($new_value, $id, $key) {\r\n  global $wpdb;\r\n  if ($key !== '_expiration-date' || ! $new_value) {\r\n    return $new_value;\r\n  }\r\n\r\n  $new_value = get_gmt_from_date($new_value, 'U');\r\n  return $new_value;\r\n}<\/pre>\n<p>Resultado:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2019\/01\/26205459\/1-3.png\" alt=\"\" width=\"585\" height=\"501\" class=\"aligncenter size-full wp-image-1553\" srcset=\"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2019\/01\/26205459\/1-3.png 585w, https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2019\/01\/26205459\/1-3-300x257.png 300w\" sizes=\"(max-width: 585px) 100vw, 585px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2><strong>C\u00f3mo editar la fecha utilizando un calendario<\/strong><\/h2>\n<p>Si quieres algo as\u00ed, necesitas el siguiente c\u00f3digo:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2019\/01\/26212231\/image.png\" alt=\"\" width=\"420\" height=\"295\" class=\"aligncenter size-full wp-image-2204\" srcset=\"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2019\/01\/26212231\/image.png 420w, https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2019\/01\/26212231\/image-300x211.png 300w\" sizes=\"(max-width: 420px) 100vw, 420px\" \/><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"php\">add_action('vg_sheet_editor\/editor\/before_init', 'wpse_modify_expiration_column', 999);\r\n\r\nfunction wpse_modify_expiration_column($editor) {\t\t\r\n  $post_type = 'post';\r\n  $meta_key = '_expiration-date';\r\n  $editor-&gt;args['columns']-&gt;register_item($meta_key, $post_type, array(\r\n    'formatted' =&gt; array('data' =&gt; $meta_key, 'type' =&gt; 'date', 'dateFormat' =&gt; 'YYYY-MM-DD', 'correctFormat' =&gt; true, 'datePickerConfig' =&gt; array('firstDay' =&gt; 0, 'showWeekNumber' =&gt; true, 'numberOfMonths' =&gt; 1))\r\n  ), true);\r\n}<\/pre>\n<h2><strong>\u00bfD\u00f3nde a\u00f1ado este c\u00f3digo?<\/strong><\/h2>\n<p>A\u00f1\u00e1delo en functions.php en tu tema o en la carpeta de temas, o puedes usar el plugin &#8220;code snippets&#8221; para cargarlo en wp-admin.<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"_acf_changed":false,"_custom_body_class":"","_custom_post_class":"","_links_to":"","_links_to_target":""},"class_list":["post-1552","snippets","type-snippets","status-publish","hentry","entry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Formato de Celda: Mostrar el Valor de la Marca de Tiempo como Fecha Amistosa - WP Sheet Editor en Espa\u00f1ol<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/wpsheeteditor.com\/es\/snippets\/formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Formato de Celda: Mostrar el Valor de la Marca de Tiempo como Fecha Amistosa - WP Sheet Editor en Espa\u00f1ol\" \/>\n<meta property=\"og:description\" content=\"Por ejemplo, nuestros mensajes tienen un campo meta con una marca de tiempo y la hoja de c\u00e1lculo muestra la marca de tiempo as\u00ed: Podemos usar el siguiente c\u00f3digo para mostrar los valores como fechas amistosas, para que podamos ver, editar y guardar la columna usando fechas amistosas: add_filter(&#039;vg_sheet_editor\/provider\/post\/update_item_meta&#039;, &#039;wpse_expiration_filter_cell_data_for_saving&#039;, 10, 3); add_filter(&#039;vg_sheet_editor\/provider\/post\/get_item_meta&#039;, &#039;wpse_expiration_filter_cell_data_for_readings&#039;, 10, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wpsheeteditor.com\/es\/snippets\/formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa\/\" \/>\n<meta property=\"og:site_name\" content=\"WP Sheet Editor en Espa\u00f1ol\" \/>\n<meta property=\"article:modified_time\" content=\"2019-07-02T03:20:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wpsheeteditor.com\/es\/wp-content\/uploads\/sites\/3\/2019\/01\/2-2.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/wpsheeteditor.com\/es\/snippets\/formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa\/\",\"url\":\"https:\/\/wpsheeteditor.com\/es\/snippets\/formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa\/\",\"name\":\"Formato de Celda: Mostrar el Valor de la Marca de Tiempo como Fecha Amistosa - WP Sheet Editor en Espa\u00f1ol\",\"isPartOf\":{\"@id\":\"https:\/\/wpsheeteditor.com\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/wpsheeteditor.com\/es\/snippets\/formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/wpsheeteditor.com\/es\/snippets\/formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/wpsheeteditor.com\/es\/wp-content\/uploads\/sites\/3\/2019\/01\/2-2.png\",\"datePublished\":\"2019-01-28T19:38:52+00:00\",\"dateModified\":\"2019-07-02T03:20:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/wpsheeteditor.com\/es\/snippets\/formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/wpsheeteditor.com\/es\/snippets\/formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/wpsheeteditor.com\/es\/snippets\/formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa\/#primaryimage\",\"url\":\"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2019\/01\/26205502\/2-2.png\",\"contentUrl\":\"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2019\/01\/26205502\/2-2.png\",\"width\":609,\"height\":333},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/wpsheeteditor.com\/es\/snippets\/formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/wpsheeteditor.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Snippets\",\"item\":\"https:\/\/wpsheeteditor.com\/es\/snippets\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Formato de Celda: Mostrar el Valor de la Marca de Tiempo como Fecha Amistosa\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/wpsheeteditor.com\/es\/#website\",\"url\":\"https:\/\/wpsheeteditor.com\/es\/\",\"name\":\"WP Sheet Editor en Espa\u00f1ol\",\"description\":\"Edita miles de posts y p\u00e1ginas r\u00e1pidamente\",\"publisher\":{\"@id\":\"https:\/\/wpsheeteditor.com\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/wpsheeteditor.com\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/wpsheeteditor.com\/es\/#organization\",\"name\":\"WP Sheet Editor\",\"url\":\"https:\/\/wpsheeteditor.com\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/wpsheeteditor.com\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2016\/06\/26203459\/logo-248x102.png\",\"contentUrl\":\"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2016\/06\/26203459\/logo-248x102.png\",\"width\":248,\"height\":102,\"caption\":\"WP Sheet Editor\"},\"image\":{\"@id\":\"https:\/\/wpsheeteditor.com\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Formato de Celda: Mostrar el Valor de la Marca de Tiempo como Fecha Amistosa - WP Sheet Editor en Espa\u00f1ol","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/wpsheeteditor.com\/es\/snippets\/formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa\/","og_locale":"es_ES","og_type":"article","og_title":"Formato de Celda: Mostrar el Valor de la Marca de Tiempo como Fecha Amistosa - WP Sheet Editor en Espa\u00f1ol","og_description":"Por ejemplo, nuestros mensajes tienen un campo meta con una marca de tiempo y la hoja de c\u00e1lculo muestra la marca de tiempo as\u00ed: Podemos usar el siguiente c\u00f3digo para mostrar los valores como fechas amistosas, para que podamos ver, editar y guardar la columna usando fechas amistosas: add_filter('vg_sheet_editor\/provider\/post\/update_item_meta', 'wpse_expiration_filter_cell_data_for_saving', 10, 3); add_filter('vg_sheet_editor\/provider\/post\/get_item_meta', 'wpse_expiration_filter_cell_data_for_readings', 10, [&hellip;]","og_url":"https:\/\/wpsheeteditor.com\/es\/snippets\/formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa\/","og_site_name":"WP Sheet Editor en Espa\u00f1ol","article_modified_time":"2019-07-02T03:20:45+00:00","og_image":[{"url":"https:\/\/wpsheeteditor.com\/es\/wp-content\/uploads\/sites\/3\/2019\/01\/2-2.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/wpsheeteditor.com\/es\/snippets\/formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa\/","url":"https:\/\/wpsheeteditor.com\/es\/snippets\/formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa\/","name":"Formato de Celda: Mostrar el Valor de la Marca de Tiempo como Fecha Amistosa - WP Sheet Editor en Espa\u00f1ol","isPartOf":{"@id":"https:\/\/wpsheeteditor.com\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/wpsheeteditor.com\/es\/snippets\/formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa\/#primaryimage"},"image":{"@id":"https:\/\/wpsheeteditor.com\/es\/snippets\/formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa\/#primaryimage"},"thumbnailUrl":"https:\/\/wpsheeteditor.com\/es\/wp-content\/uploads\/sites\/3\/2019\/01\/2-2.png","datePublished":"2019-01-28T19:38:52+00:00","dateModified":"2019-07-02T03:20:45+00:00","breadcrumb":{"@id":"https:\/\/wpsheeteditor.com\/es\/snippets\/formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wpsheeteditor.com\/es\/snippets\/formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/wpsheeteditor.com\/es\/snippets\/formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa\/#primaryimage","url":"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2019\/01\/26205502\/2-2.png","contentUrl":"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2019\/01\/26205502\/2-2.png","width":609,"height":333},{"@type":"BreadcrumbList","@id":"https:\/\/wpsheeteditor.com\/es\/snippets\/formato-celda-mostrar-valor-marca-tiempo-fecha-amistosa\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/wpsheeteditor.com\/es\/"},{"@type":"ListItem","position":2,"name":"Snippets","item":"https:\/\/wpsheeteditor.com\/es\/snippets\/"},{"@type":"ListItem","position":3,"name":"Formato de Celda: Mostrar el Valor de la Marca de Tiempo como Fecha Amistosa"}]},{"@type":"WebSite","@id":"https:\/\/wpsheeteditor.com\/es\/#website","url":"https:\/\/wpsheeteditor.com\/es\/","name":"WP Sheet Editor en Espa\u00f1ol","description":"Edita miles de posts y p\u00e1ginas r\u00e1pidamente","publisher":{"@id":"https:\/\/wpsheeteditor.com\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wpsheeteditor.com\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/wpsheeteditor.com\/es\/#organization","name":"WP Sheet Editor","url":"https:\/\/wpsheeteditor.com\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/wpsheeteditor.com\/es\/#\/schema\/logo\/image\/","url":"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2016\/06\/26203459\/logo-248x102.png","contentUrl":"https:\/\/media.wpsheeteditor.com\/wp-content\/uploads\/sites\/3\/2016\/06\/26203459\/logo-248x102.png","width":248,"height":102,"caption":"WP Sheet Editor"},"image":{"@id":"https:\/\/wpsheeteditor.com\/es\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/wpsheeteditor.com\/es\/wp-json\/wp\/v2\/snippets\/1552","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wpsheeteditor.com\/es\/wp-json\/wp\/v2\/snippets"}],"about":[{"href":"https:\/\/wpsheeteditor.com\/es\/wp-json\/wp\/v2\/types\/snippets"}],"wp:attachment":[{"href":"https:\/\/wpsheeteditor.com\/es\/wp-json\/wp\/v2\/media?parent=1552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}