{"id":3460,"date":"2023-10-26T09:28:07","date_gmt":"2023-10-26T09:28:07","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/formatdatetime\/"},"modified":"2023-12-03T13:06:46","modified_gmt":"2023-12-03T13:06:46","slug":"formatdatetime","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/formatdatetime\/","title":{"rendered":"Wie verwende ich die vba-funktion formatdatetime?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-2961843457\"><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>Die VBA-Funktion FORMATDATETIME ist in der Datentypkonvertierungskategorie der VBA-Funktionen aufgef\u00fchrt. Wenn Sie es im VBA-Code verwenden, <strong>gibt es eine Zeichenfolge zur\u00fcck, indem es ein Datums- und Uhrzeitformat darauf anwendet und diese als Zeichenfolge zur\u00fcckgibt<\/strong> . Einfach ausgedr\u00fcckt: Wenn Sie einen Ausdruck anwenden, kann dieser ein Daten- und Zeitformat darauf anwenden.<\/p><h2 class=\"wp-block-heading\"> Syntax<\/h2><p> <strong>FormatDateTime(Expression, [NamedFormat])<\/strong><\/p><h2 class=\"wp-block-heading\"> Argumente<\/h2><ul><li> <strong>Ausdruck<\/strong> : Der Wert, den Sie als Datum formatieren m\u00f6chten.<\/li><li> <strong>[NamedFormat]<\/strong> : Eine vbDateTimeFormat-Enumeration zur Angabe des Formats, das Sie auf den Ausdruck anwenden m\u00f6chten.<ul><li> vbGeneral: entsprechend der allgemeinen Datumseinstellung des Systems.<\/li><li> vbLongDate: Gem\u00e4\u00df den Systemeinstellungen f\u00fcr langes Datum.<\/li><li> vbLongTime: entsprechend den Langzeiteinstellungen des Systems.<\/li><li> vbShortDate: Gem\u00e4\u00df den Kurzdatumseinstellungen des Systems.<\/li><li> vbShortTime: entsprechend den Kurzzeiteinstellungen des Systems.<\/li><\/ul><\/li><\/ul><h2 class=\"wp-block-heading\"> Beispiel<\/h2><p> Um praktisch zu verstehen, wie die VBA-Funktion FORMATDATETIME verwendet wird, m\u00fcssen Sie das folgende Beispiel durchgehen, in dem wir damit einen VBA-Code geschrieben haben: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"example-vba-formatdatetime-function\" 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><\/div><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><p> Im obigen Code haben wir FORMATDATETIME verwendet, um den Wert in Zelle A1 in einen g\u00fcltigen Datums- und Uhrzeitwert (gem\u00e4\u00df VBA) umzuwandeln und das Ergebnis in Zelle B1 zur\u00fcckgegeben.<\/p><h2 class=\"wp-block-heading\"> Kommentare<\/h2><ul><li> Wenn der angegebene Wert ein anderer Wert als ein Datum und eine Uhrzeit oder eine Zeichenfolge ist, die nicht als Datum und Uhrzeit erkannt werden kann, gibt VBA den Laufzeitfehler 13 zur\u00fcck. <\/li><\/ul><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Weitere Tutorials <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-264\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/de\/cbyte\/\">Byte-VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/ccur\/\">VBA CCUR<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/cdate\/\">CDATE VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/cdbl\/\">VBA CDBL<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/cdec\/\">VBA-CDEC<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","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-3460","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>\u25b7 Wie verwende ich die VBA-Funktion FORMATDATETIME?<\/title>\n<meta name=\"description\" content=\"Erfahren Sie, wie Sie die VBA-Funktion FORMATDATETIME mit Syntax, Argumenten und einem Beispiel mit Beispielcode verwenden.\" \/>\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\/de\/formatdatetime\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Wie verwende ich die VBA-Funktion FORMATDATETIME?\" \/>\n<meta property=\"og:description\" content=\"Erfahren Sie, wie Sie die VBA-Funktion FORMATDATETIME mit Syntax, Argumenten und einem Beispiel mit Beispielcode verwenden.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/formatdatetime\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T13:06:46+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=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/de\/formatdatetime\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/formatdatetime\/\",\"name\":\"\u25b7 Wie verwende ich die VBA-Funktion FORMATDATETIME?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/formatdatetime\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/formatdatetime\/#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-03T13:06:46+00:00\",\"description\":\"Erfahren Sie, wie Sie die VBA-Funktion FORMATDATETIME mit Syntax, Argumenten und einem Beispiel mit Beispielcode verwenden.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/formatdatetime\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/formatdatetime\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/formatdatetime\/#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\/de\/formatdatetime\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie verwende ich die vba-funktion formatdatetime?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"name\":\"Excel Advisor\",\"description\":\"Ihr Leitfaden zur Datendominanz\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Wie verwende ich die VBA-Funktion FORMATDATETIME?","description":"Erfahren Sie, wie Sie die VBA-Funktion FORMATDATETIME mit Syntax, Argumenten und einem Beispiel mit Beispielcode verwenden.","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\/de\/formatdatetime\/","og_locale":"de_DE","og_type":"article","og_title":"\u25b7 Wie verwende ich die VBA-Funktion FORMATDATETIME?","og_description":"Erfahren Sie, wie Sie die VBA-Funktion FORMATDATETIME mit Syntax, Argumenten und einem Beispiel mit Beispielcode verwenden.","og_url":"https:\/\/exceladvisor.org\/de\/formatdatetime\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T13:06:46+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":{"Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/de\/formatdatetime\/","url":"https:\/\/exceladvisor.org\/de\/formatdatetime\/","name":"\u25b7 Wie verwende ich die VBA-Funktion FORMATDATETIME?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/formatdatetime\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/formatdatetime\/#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-03T13:06:46+00:00","description":"Erfahren Sie, wie Sie die VBA-Funktion FORMATDATETIME mit Syntax, Argumenten und einem Beispiel mit Beispielcode verwenden.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/formatdatetime\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/formatdatetime\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/formatdatetime\/#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\/de\/formatdatetime\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie verwende ich die vba-funktion formatdatetime?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/de\/#website","url":"https:\/\/exceladvisor.org\/de\/","name":"Excel Advisor","description":"Ihr Leitfaden zur Datendominanz","publisher":{"@id":"https:\/\/exceladvisor.org\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/de\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3460","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/comments?post=3460"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3460\/revisions"}],"predecessor-version":[{"id":4297,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3460\/revisions\/4297"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}