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
|
<HTML>
<HEAD>
<TITLE>Date and time</TITLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF" TEXT="#000000">
<P><font size="+2" color="green"><B>Date and time</B></font></P>
<p>
The <code><a href="../Functions/StringManipulation/date.htm">DATE</a></CODE> function
returns the current date as a string using multiple formats.
The <code><a href="../Functions/StringManipulation/time.htm">TIME</a></CODE>
function returns the current time as a string, also in multiple formats. For example:</P>
<P>
<font color="blue"><pre>
<font color="blue">=DATE('mmmm d yyyy')</font>
<font color="orange">APRIL 16 2007</font>
<font color="blue">=TIME</font>
<font color="orange">11:58:16</font>
</PRE></font></P>
<P>
So, the current date and time could be drawn with:</P>
<P>
<CODE><font color="blue">TEXT TIME//' '//DATE('mmmm d yyyy')</font></CODE></P>
<P>
<a href="formatting.htm"><img src="../shadow_left.gif">
<font size="+1" color="olive">Formatting</font></a><br />
<a href="example.htm"><img src="../shadow_right.gif">
<font size="+1" color="olive">Examples</font></a></p>
</BODY>
</HTML>
|
