{"id":3433,"date":"2023-10-27T14:04:07","date_gmt":"2023-10-27T14:04:07","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/cdate\/"},"modified":"2023-12-03T13:06:26","modified_gmt":"2023-12-03T13:06:26","slug":"cdate","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/cdate\/","title":{"rendered":"Wie verwende ich die vba-cdate-funktion?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-706313861\"><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-CDATE-Funktion ist in der Datentypkonvertierungskategorie der VBA-Funktionen aufgef\u00fchrt. Wenn Sie es im VBA-Code verwenden, <strong>konvertiert es einen Ausdruck in den Datumsdatentyp<\/strong> . Einfach ausgedr\u00fcckt kann der Datentyp \u201eDatum\u201c einen Wert enthalten, der das Datum und die Uhrzeit gem\u00e4\u00df dem g\u00fcltigen Datums- und Uhrzeitsystem von VBA enth\u00e4lt.<\/p><h2 class=\"wp-block-heading\"> Syntax<\/h2><p> <strong>CDate(Ausdruck)<\/strong><\/p><h2 class=\"wp-block-heading\"> Argumente<\/h2><ul><li> <strong>Ausdruck<\/strong> : Der Wert, den Sie in einen Datumsdatentyp konvertieren m\u00f6chten.<\/li><\/ul><h2 class=\"wp-block-heading\"> Beispiel<\/h2><p> Um die Verwendung der VBA-CDATE-Funktion praktisch zu verstehen, 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=\"Beispiel-vba-cdate-Funktion\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cdate.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-cdate-function\" width=\"751\" height=\"569\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_CDATE() Range(\"B1\").Value = CDate(Range(\"A1\")) End Sub<\/code><\/pre><p> Im obigen Beispiel haben wir den Wert aus Zelle A1 verwendet, in der wir eine Zahl (8,5694) haben. Dann haben wir die Funktion CDATE verwendet, um diesen Wert in den Datentyp \u201eDatum\u201c zu konvertieren, und als Ergebnis wurde 08\/07\/2018 0:00 zur\u00fcckgegeben.<\/p><h2 class=\"wp-block-heading\"> Kommentare<\/h2><ul><li> Es kann Textdarstellungen von Datums- und Uhrzeitangaben interpretieren, die von VBA als Excel-Datums- und Uhrzeitformat erkannt werden k\u00f6nnen.<\/li><li> Ein Wert, der nicht in ein Datum und eine Uhrzeit konvertiert werden kann. VBA gibt 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-35\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/de\/cdec\/\">VBA-CDEC<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/chr\/\">VBA CHR<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/cint\/\">VBA CINT<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/clng\/\">CLNG VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/csng\/\">VBA CSNG<\/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-3433","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>Wie verwende ich die VBA-CDATE-Funktion? (Syntax + Beispiel)<\/title>\n<meta name=\"description\" content=\"Erfahren Sie, wie Sie die VBA-CDATE-Funktion mit Syntax, Argumenten und Beispielen 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\/cdate\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wie verwende ich die VBA-CDATE-Funktion? (Syntax + Beispiel)\" \/>\n<meta property=\"og:description\" content=\"Erfahren Sie, wie Sie die VBA-CDATE-Funktion mit Syntax, Argumenten und Beispielen mit Beispielcode verwenden.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/cdate\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T13:06:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cdate.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\/cdate\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/cdate\/\",\"name\":\"Wie verwende ich die VBA-CDATE-Funktion? (Syntax + Beispiel)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/cdate\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/cdate\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cdate.png\",\"datePublished\":\"2023-10-27T14:04:07+00:00\",\"dateModified\":\"2023-12-03T13:06:26+00:00\",\"description\":\"Erfahren Sie, wie Sie die VBA-CDATE-Funktion mit Syntax, Argumenten und Beispielen mit Beispielcode verwenden.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/cdate\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/cdate\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/cdate\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cdate.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cdate.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/cdate\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie verwende ich die vba-cdate-funktion?\"}]},{\"@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":"Wie verwende ich die VBA-CDATE-Funktion? (Syntax + Beispiel)","description":"Erfahren Sie, wie Sie die VBA-CDATE-Funktion mit Syntax, Argumenten und Beispielen 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\/cdate\/","og_locale":"de_DE","og_type":"article","og_title":"Wie verwende ich die VBA-CDATE-Funktion? (Syntax + Beispiel)","og_description":"Erfahren Sie, wie Sie die VBA-CDATE-Funktion mit Syntax, Argumenten und Beispielen mit Beispielcode verwenden.","og_url":"https:\/\/exceladvisor.org\/de\/cdate\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T13:06:26+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cdate.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\/cdate\/","url":"https:\/\/exceladvisor.org\/de\/cdate\/","name":"Wie verwende ich die VBA-CDATE-Funktion? (Syntax + Beispiel)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/cdate\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/cdate\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cdate.png","datePublished":"2023-10-27T14:04:07+00:00","dateModified":"2023-12-03T13:06:26+00:00","description":"Erfahren Sie, wie Sie die VBA-CDATE-Funktion mit Syntax, Argumenten und Beispielen mit Beispielcode verwenden.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/cdate\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/cdate\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/cdate\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cdate.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cdate.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/cdate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie verwende ich die vba-cdate-funktion?"}]},{"@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\/3433","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=3433"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3433\/revisions"}],"predecessor-version":[{"id":4277,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3433\/revisions\/4277"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3433"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}