-
Notifications
You must be signed in to change notification settings - Fork 4
Expand file tree
/
Copy path576.html
More file actions
65 lines (65 loc) · 1.56 KB
/
Copy path576.html
File metadata and controls
65 lines (65 loc) · 1.56 KB
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
63
64
65
<h1 id="datefmt">DATEFMT</h1>
<blockquote>
<p>s = DATEFMT (format, dmy| (d,m,y)| julian_date)</p>
</blockquote>
<p>Returns a formatted date string. The input date can be given as a
date-string returned by DATE, as the integers <code>d</code> for day,
<code>m</code> for month and <code>y</code> for year, or as a julian
date. <code>format</code> is a string specifying the format of the
date:</p>
<table>
<thead>
<tr class="header">
<th>Format</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr class="odd">
<td>D</td>
<td>one or two digits of Day</td>
</tr>
<tr class="even">
<td>DD</td>
<td>2-digit day</td>
</tr>
<tr class="odd">
<td>DDD</td>
<td>3-char day name</td>
</tr>
<tr class="even">
<td>DDDD</td>
<td>full day name</td>
</tr>
<tr class="odd">
<td>M</td>
<td>1 or 2 digits of month</td>
</tr>
<tr class="even">
<td>MM</td>
<td>2-digit month</td>
</tr>
<tr class="odd">
<td>MMM</td>
<td>3-char month name</td>
</tr>
<tr class="even">
<td>MMMM</td>
<td>full month name</td>
</tr>
<tr class="odd">
<td>YY</td>
<td>2-digit year (2K)</td>
</tr>
<tr class="even">
<td>YYYY</td>
<td>4-digit year</td>
</tr>
</tbody>
</table>
<p>See also DATE and DATEDMY.</p>
<h3 id="example">Example</h3>
<pre><code>PRINT DATEFMT("ddd dd, mm/yy", 23, 11, 2001) ' Output: Fri 23, 11/01
PRINT DATEFMT("mm.dd.yy" , "23/11/2001") ' Output: 11.23.01
PRINT DATEFMT("dd.mm.yyyy" , DATE) ' Output: 19.10.2023
PRINT DATEFMT("dddd" , JULIAN("23/11/2001")) ' Output: Friday</code></pre>