Difference between revisions of "SET DATEFORMAT"
From Lianjapedia
Yvonne.milne (Talk | contribs) (Created page with "''Under construction'' ==Purpose== Determine input and output date formats ==Syntax== SET DATEFORMAT [TO] AMERICAN | ANSI | BRITISH | DMY | FORMAT <cISOlocale> | FRENCH | GER...") |
Yvonne.milne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
==Purpose== | ==Purpose== | ||
| − | Determine | + | Determine UI date formats for datetextbox formitems and grid columns |
==Syntax== | ==Syntax== | ||
| − | SET DATEFORMAT | + | SET DATEFORMAT ON | OFF | (<expL>) |
| + | |||
| + | SET DATEFORMAT TO <expC> | ||
==See Also== | ==See Also== | ||
| − | [[CTOD()]], [[DATE()]], [[DMY()]], [[DTOC()]], [[DTOS()]], [[DTOV()]], [[LOCALE()]], [[MDY()]], [[SET CENTURY]], [[SET DATE]], [[SET EPOCH]], [[SET MARK]], [[STOD()]], [[VTOD()]] | + | [[Advanced Canvas Control Attributes]], [[Canvas Section Attributes]], [[CTOD()]], [[DATE()]], [[DMY()]], [[DTOC()]], [[DTOS()]], [[DTOV()]], [[Form Section Attributes]], [[Grid Column Attributes]], [[Grid Section Attributes]], [[LOCALE()]], [[MDY()]], [[SET CENTURY]], [[SET DATE]], [[SET EPOCH]], [[SET MARK]], [[STOD()]], [[VTOD()]] |
==Description== | ==Description== | ||
| − | The SET DATEFORMAT command | + | The SET DATEFORMAT command can be used to configure the date format for datetextbox formitems and grid columns. |
| + | |||
| + | The <expC> is the format string comprising the following: | ||
{| class="wikitable" width="100%" | {| class="wikitable" width="100%" | ||
| − | !width=" | + | !width="20%"|Format||Description |
|- | |- | ||
| − | | | + | |d||day as number without a leading zero (1 to 31) |
|- | |- | ||
| − | | | + | |dd||day as number with a leading zero (01 to 31) |
|- | |- | ||
| − | | | + | |ddd||abbreviated localized day name (e.g. 'Mon' to 'Sun') |
|- | |- | ||
| − | | | + | |dddd||long localized day name (e.g. 'Monday' to 'Sunday') |
|- | |- | ||
| − | | | + | |M||month as number without a leading zero (1-12) |
|- | |- | ||
| − | | | + | |MM||month as number with a leading zero (01-12) |
|- | |- | ||
| − | | | + | |MMM||abbreviated localized month name (e.g. 'Jan' to 'Dec') |
|- | |- | ||
| − | | | + | |MMMM||long localized month name (e.g. 'January' to 'December') |
|- | |- | ||
| − | | | + | |yy||year as two digit number (00-99) |
|- | |- | ||
| − | | | + | |yyyy||year as four digit number |
|- | |- | ||
|} | |} | ||
| − | |||
| − | |||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | set date | + | set dateformat on |
| − | + | set date to locale | |
| − | + | ||
| − | set | + | //or |
| − | + | ||
| − | + | set dateformat to "d.MM.yyyy" | |
| − | + | ||
</code> | </code> | ||
Revision as of 07:32, 18 May 2021
Contents
Purpose
Determine UI date formats for datetextbox formitems and grid columns
Syntax
SET DATEFORMAT ON | OFF | (<expL>)
SET DATEFORMAT TO <expC>
See Also
Advanced Canvas Control Attributes, Canvas Section Attributes, CTOD(), DATE(), DMY(), DTOC(), DTOS(), DTOV(), Form Section Attributes, Grid Column Attributes, Grid Section Attributes, LOCALE(), MDY(), SET CENTURY, SET DATE, SET EPOCH, SET MARK, STOD(), VTOD()
Description
The SET DATEFORMAT command can be used to configure the date format for datetextbox formitems and grid columns.
The <expC> is the format string comprising the following:
| Format | Description |
|---|---|
| d | day as number without a leading zero (1 to 31) |
| dd | day as number with a leading zero (01 to 31) |
| ddd | abbreviated localized day name (e.g. 'Mon' to 'Sun') |
| dddd | long localized day name (e.g. 'Monday' to 'Sunday') |
| M | month as number without a leading zero (1-12) |
| MM | month as number with a leading zero (01-12) |
| MMM | abbreviated localized month name (e.g. 'Jan' to 'Dec') |
| MMMM | long localized month name (e.g. 'January' to 'December') |
| yy | year as two digit number (00-99) |
| yyyy | year as four digit number |
Example
set dateformat on set date to locale //or set dateformat to "d.MM.yyyy"
