1 <?xml version=
"1.0" encoding=
"UTF-8"?>
4 <!--***********************************************************************
6 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
8 * Copyright 2008 by Sun Microsystems, Inc.
10 * OpenOffice.org - a multi-platform office productivity suite
12 * $RCSfile: 03030107.xhp,v $
15 * This file is part of OpenOffice.org.
17 * OpenOffice.org is free software: you can redistribute it and/or modify
18 * it under the terms of the GNU Lesser General Public License version 3
19 * only, as published by the Free Software Foundation.
21 * OpenOffice.org is distributed in the hope that it will be useful,
22 * but WITHOUT ANY WARRANTY; without even the implied warranty of
23 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
24 * GNU Lesser General Public License version 3 for more details
25 * (a copy is included in the LICENSE file that accompanied this code).
27 * You should have received a copy of the GNU Lesser General Public License
28 * version 3 along with OpenOffice.org. If not, see
29 * <http://www.openoffice.org/license.html>
30 * for a copy of the LGPLv3 License.
32 ************************************************************************-->
34 <helpdocument version=
"1.0">
36 <topic id=
"textsbasicshared03030107xml" indexer=
"include" status=
"PUBLISH">
37 <title id=
"tit" xml-lang=
"en-US">CDateToIso Function [Runtime]
</title>
38 <filename>/text/sbasic/shared/
03030107.xhp
</filename>
41 <created date=
"2003-10-31T00:00:00">Sun Microsystems, Inc.
</created>
42 <lastedited date=
"2004-08-24T09:53:34">converted from old format - fpe
</lastedited>
46 <section id=
"cdatetoiso">
47 <bookmark xml-lang=
"en-US" branch=
"index" id=
"bm_id3150620"><bookmark_value>CdateToIso function
</bookmark_value>
49 <paragraph role=
"heading" id=
"hd_id3150620" xml-lang=
"en-US" level=
"1" l10n=
"U" oldref=
"1"><link href=
"text/sbasic/shared/03030107.xhp" name=
"CDateToIso Function [Runtime]">CDateToIso Function [Runtime]
</link></paragraph>
50 <paragraph role=
"paragraph" id=
"par_id3151097" xml-lang=
"en-US" l10n=
"U" oldref=
"2">Returns the date in ISO format from a serial date number that is generated by the DateSerial or the DateValue function.
</paragraph>
52 <paragraph role=
"heading" id=
"hd_id3159224" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"3">Syntax:
</paragraph>
53 <paragraph role=
"paragraph" id=
"par_id3149497" xml-lang=
"en-US" l10n=
"U" oldref=
"4">CDateToIso(Number)
</paragraph>
54 <paragraph role=
"heading" id=
"hd_id3152347" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"5">Return value:
</paragraph>
55 <paragraph role=
"paragraph" id=
"par_id3154422" xml-lang=
"en-US" l10n=
"U" oldref=
"6">String
</paragraph>
56 <paragraph role=
"heading" id=
"hd_id3147303" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"7">Parameters:
</paragraph>
57 <paragraph role=
"paragraph" id=
"par_id3145136" xml-lang=
"en-US" l10n=
"U" oldref=
"8">
58 <emph>Number:
</emph> Integer that contains the serial date number.
</paragraph>
59 <embed href=
"text/sbasic/shared/00000003.xhp#errorcode"/>
60 <embed href=
"text/sbasic/shared/00000003.xhp#err5"/>
61 <paragraph role=
"heading" id=
"hd_id3147243" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"9">Example:
</paragraph>
62 <paragraph role=
"paragraph" id=
"par_id3156152" xml-lang=
"en-US" l10n=
"U" oldref=
"10">Sub ExampleCDateToIso
</paragraph>
63 <paragraph role=
"paragraph" id=
"par_id3153126" xml-lang=
"en-US" l10n=
"U" oldref=
"11">MsgBox
"" & CDateToIso(Now) ,
64,
"ISO Date"</paragraph>
64 <paragraph role=
"paragraph" id=
"par_id3143228" xml-lang=
"en-US" l10n=
"U" oldref=
"12">End Sub
</paragraph>