helpcontent2/source/text/sbasic/shared/03030107.xhp


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62

<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
<!--
 * This file is part of the LibreOffice project.
 *
 * This Source Code Form is subject to the terms of the Mozilla Public
 * License, v. 2.0. If a copy of the MPL was not distributed with this
 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
 *
 * This file incorporates work covered by the following license notice:
 *
 *   Licensed to the Apache Software Foundation (ASF) under one or more
 *   contributor license agreements. See the NOTICE file distributed
 *   with this work for additional information regarding copyright
 *   ownership. The ASF licenses this file to you under the Apache
 *   License, Version 2.0 (the "License"); you may not use this file
 *   except in compliance with the License. You may obtain a copy of
 *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->

<meta>
  <topic id="textsbasicshared03030107xml" indexer="include" status="PUBLISH">
    <title id="tit" xml-lang="en-US">CDateToIso Function</title>
    <filename>/text/sbasic/shared/03030107.xhp</filename>
  </topic>
</meta>

<body>

<section id="cdatetoiso">
<bookmark xml-lang="en-US" branch="index" id="bm_id3150620">
  <bookmark_value>CdateToIso function</bookmark_value>
</bookmark>

<h1 id="hd_id3150620"><link href="text/sbasic/shared/03030107.xhp">CDateToIso Function</link></h1>
<paragraph id="par_id3151097" role="paragraph" xml-lang="en-US">Returns the date in ISO format without separators (YYYYMMDD) from a serial date number that is generated by the DateSerial or the DateValue or the CDateFromIso function.</paragraph>
<paragraph id="par_id3151098" role="paragraph" xml-lang="en-US">The year part consists of at least four digits, with leading zeros if the absolute value is less than 1000, it can be negative with a leading minus sign if the date passed denotes a year before the common era (BCE) and it can have more than four digits if the absolute value is greater than 9999. The formatted string returned can be in the range "-327680101" to "327671231".</paragraph>
<paragraph id="par_id3151099" role="note" xml-lang="en-US">Years less than 100 and greater than 9999 are supported since %PRODUCTNAME 5.4.</paragraph>
</section>

<h2 id="hd_id3159224">Syntax:</h2>
<bascode>
<paragraph id="par_id3149497" role="bascode" xml-lang="en-US">CDateToIso(Number)</paragraph>
</bascode>

<h2 id="hd_id3152347">Return value:</h2>
<paragraph id="par_id3154422" role="paragraph" xml-lang="en-US">String</paragraph>

<h2 id="hd_id3147303">Parameters:</h2>
<paragraph id="par_id3145136" role="paragraph" xml-lang="en-US"> <emph>Number:</emph> Integer that contains the serial date number.</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>

<h2 id="hd_id3147243">Example:</h2>
<bascode>
<paragraph id="par_idm1341132912" role="bascode" localize="false" xml-lang="en-US">Sub ExampleCDateToIso</paragraph>
<paragraph id="par_id3153126" role="bascode" xml-lang="en-US">    MsgBox "" &amp; CDateToIso(Now) ,64,"ISO Date"</paragraph>
<paragraph id="par_idm1341129856" role="bascode" localize="false" xml-lang="en-US">End Sub</paragraph>
</bascode>
</body>

</helpdocument>