Difference between revisions of "Date Expressions"

From Keyfax Wiki
Jump to: navigation, search
Line 1: Line 1:
  
−
{| table start, required
 
−
|+ table caption, optional; only between table start and table row
 
−
|- table row, optional on first row—wiki engine assumes the first row
 
−
! table header cell, optional. Consecutive table header cells may be added on same line separated by double marks (!!) or start on new lines, each with its own single mark (!).
 
−
| table data cell, optional. Consecutive table data cells may be added on same line separated by double marks (||) or start on new lines, each with its own single mark (|).
 
−
|} table end, required
 
  
 
{| class="wikitable"
 
{| class="wikitable"
Line 23: Line 17:
 
|Mon 15 Oct 2018 - 20:00
 
|Mon 15 Oct 2018 - 20:00
 
|A date entry is formatted to the required layout
 
|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
 
|}
 
|}

Revision as of 11:52, 27 February 2018


As Date Expressions
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
Retrieved from ‘http://wiki.keyfax.biz/index.php?title=Date_Expressions&oldid=518’