{"id":495,"date":"2023-10-26T09:28:07","date_gmt":"2023-10-26T09:28:07","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/formatofechahora\/"},"modified":"2023-12-25T10:30:27","modified_gmt":"2023-12-25T10:30:27","slug":"formatofechahora","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/formatofechahora\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba formatdatetime?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-542220317\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>La funci\u00f3n VBA FORMATDATETIME aparece en la categor\u00eda de conversi\u00f3n de tipo de datos de las funciones VBA. Cuando lo usa en c\u00f3digo VBA, <strong>devuelve una cadena aplic\u00e1ndole un formato de fecha y hora y la devuelve como una cadena<\/strong> . En pocas palabras, cuando aplica una expresi\u00f3n, puede aplicarle un formato de datos y hora.<\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>FormatDateTime(Expresi\u00f3n, [NamedFormat])<\/strong><\/p>\n<h2 class=\"wp-block-heading\"> Argumentos<\/h2>\n<ul>\n<li> <strong>Expresi\u00f3n<\/strong> : el valor que desea formatear como fecha.<\/li>\n<li> <strong>[NamedFormat]<\/strong> : una enumeraci\u00f3n vbDateTimeFormat para especificar el formato que desea aplicar a la expresi\u00f3n.\n<ul>\n<li> vbGeneral: seg\u00fan la configuraci\u00f3n de fecha general del sistema.<\/li>\n<li> vbLongDate: seg\u00fan la configuraci\u00f3n de fecha larga del sistema.<\/li>\n<li> vbLongTime: seg\u00fan la configuraci\u00f3n de Long Time del sistema.<\/li>\n<li> vbShortDate: Seg\u00fan la configuraci\u00f3n de fecha corta del sistema.<\/li>\n<li> vbShortTime: seg\u00fan la configuraci\u00f3n de Short Time del sistema.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Ejemplo<\/h2>\n<p> Para comprender pr\u00e1cticamente c\u00f3mo usar la funci\u00f3n VBA FORMATDATETIME, debe seguir el siguiente ejemplo donde escribimos un c\u00f3digo vba us\u00e1ndola: <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"ejemplo-vba-formato-fecha-hora-funci\u00f3n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-vba-formatdatetime-fonction.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-formatdatetime-function\" width=\"837\" height=\"451\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_FORMATDATETIME() Range(\"B1\").Value = FormatDateTime(Range(\"A1\")) End Sub<\/code><\/pre>\n<p> En el c\u00f3digo anterior, usamos FORMATDATETIME para convertir el valor en la celda A1 a un valor de fecha y hora v\u00e1lido (seg\u00fan VBA) y devolvimos el resultado en la celda B1.<\/p>\n<h2 class=\"wp-block-heading\"> Comentarios<\/h2>\n<ul>\n<li> Si el valor especificado es un valor distinto de una fecha y hora o una cadena que no se puede reconocer como fecha y hora, VBA devolver\u00e1 el error de tiempo de ejecuci\u00f3n 13. <\/li>\n<\/ul>\n<div class=\"wp-block-group more-tutorials is-layout-flow\">\n<div class=\"wp-block-group__inner-container\">\n<h2 class=\"wp-block-heading\"> M\u00e1s tutoriales <\/h2>\n<div class=\"wp-block-columns is-layout-flex wp-container-264\">\n<div class=\"wp-block-column is-layout-flow\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/cbyte\/\">Bytes VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/ocurre\/\">VBA CCUR<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/fecha-c\/\">CDATE VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/cdbl\/\">VBA CDBL<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/cdec\/\">CDEC VBA<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n VBA FORMATDATETIME aparece en la categor\u00eda de conversi\u00f3n de tipo de datos de las funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve una cadena aplic\u00e1ndole un formato de fecha y hora y la devuelve como una cadena . En pocas palabras, cuando aplica una expresi\u00f3n, puede aplicarle un formato de datos y [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-495","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfc\u00f3mo utilizar la funci\u00f3n vba formatdatetime?<\/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:\/\/exceladvisor.org\/es\/formatofechahora\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba formatdatetime?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n VBA FORMATDATETIME aparece en la categor\u00eda de conversi\u00f3n de tipo de datos de las funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve una cadena aplic\u00e1ndole un formato de fecha y hora y la devuelve como una cadena . En pocas palabras, cuando aplica una expresi\u00f3n, puede aplicarle un formato de datos y [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/formatofechahora\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:30:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-vba-formatdatetime-fonction.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:\/\/exceladvisor.org\/es\/formatofechahora\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/formatofechahora\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba formatdatetime?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/formatofechahora\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/formatofechahora\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-vba-formatdatetime-fonction.png\",\"datePublished\":\"2023-10-26T09:28:07+00:00\",\"dateModified\":\"2023-12-25T10:30:27+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/formatofechahora\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/formatofechahora\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/formatofechahora\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-vba-formatdatetime-fonction.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-vba-formatdatetime-fonction.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/formatofechahora\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba formatdatetime?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba formatdatetime?","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:\/\/exceladvisor.org\/es\/formatofechahora\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba formatdatetime?","og_description":"La funci\u00f3n VBA FORMATDATETIME aparece en la categor\u00eda de conversi\u00f3n de tipo de datos de las funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve una cadena aplic\u00e1ndole un formato de fecha y hora y la devuelve como una cadena . En pocas palabras, cuando aplica una expresi\u00f3n, puede aplicarle un formato de datos y [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/formatofechahora\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:30:27+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-vba-formatdatetime-fonction.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:\/\/exceladvisor.org\/es\/formatofechahora\/","url":"https:\/\/exceladvisor.org\/es\/formatofechahora\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba formatdatetime?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/formatofechahora\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/formatofechahora\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-vba-formatdatetime-fonction.png","datePublished":"2023-10-26T09:28:07+00:00","dateModified":"2023-12-25T10:30:27+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/formatofechahora\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/formatofechahora\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/formatofechahora\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-vba-formatdatetime-fonction.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-vba-formatdatetime-fonction.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/formatofechahora\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba formatdatetime?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/495","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=495"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/495\/revisions"}],"predecessor-version":[{"id":1268,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/495\/revisions\/1268"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}