Difference between revisions of "Format"
From Keyfax Wiki
(Created page with "Combined with the AsDate and the following arguments, Format is used to choose how you wish to display any date. {| class="wikitable" |+ style="text-align:left;" | AsDate...") |
(No difference)
|
Latest revision as of 10:43, 14 August 2019
Combined with the AsDate and the following arguments, Format is used to choose how you wish to display any date.
| Expression | Databox Value | Result | Comments |
|---|---|---|---|
| AsDate | "15-10-2018 08:00pm" | 15/10/2018 20:00:00 | A date entry is converted into a simple date format |
| AsDate Format ("ddd dd MMM yyyy - HH:mm") | "15-10-2018 08:00pm" | Mon 15 Oct 2018 - 20:00 | A date entry is formatted to the required layout |
| AsDate Format (‘d’) | "15-10-2018 08:00pm" | 15/10/2018 | A date entry is converted into day/month/year |
| AsDate Format (‘dd’) | "15-10-2018 08:00pm" | 15 | A date entry is converted into day of the month |
| AsDate Format (‘ddd’) | "15-10-2018 08:00pm" | Mon | A date entry is converted into short name for day |
| AsDate Format (‘dddd’) | "15-10-2018 08:00pm" | Monday | A date entry is converted into full name for day |
| AsDate Format (‘D’) | "15-10-2018 08:00pm" | 15 Oct 2018 | A date entry is converted into day month year (with short month name) |
| AsDate Format (‘m') | "15-10-2018 08:00pm" | 15 Oct | A date entry is converted into day month (with short month name) |
| AsDate Format (‘mm') | "15-10-2018 08:00pm" | 00 (minutes) | A date entry is converted into the minutes past the hour |
| AsDate Format (‘MM’) | "15-10-2018 08:00pm" | 10 | A date entry is converted into the month |
| AsDate Format (‘MMM’) | "15-10-2018 08:00pm" | Oct | A date entry is converted into the month (with short month name) |
| AsDate Format (‘y’) | "15-10-2018 08:00pm" | Oct 2018 | A date entry is converted into month year (with short month name) |
| AsDate Format (‘yy’) | "15-10-2018 08:00pm" | 18 | A date entry is converted into final two numbers of the year |
| AsDate Format (‘yyy’) | "15-10-2018 08:00pm" | 2018 | A date entry is converted into the year |
