Date Expressions
From Keyfax Wiki
| 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 |
