Difference between revisions of "Date Expressions"

From Keyfax Wiki
Jump to: navigation, search
(Created page with " {| 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 he...")
 
Line 18: Line 18:
 
|15/10/2018 20:00:00
 
|15/10/2018 20:00:00
 
|A date entry is converted into a simple date format
 
|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
 
|}
 
|}

Revision as of 11:19, 27 February 2018

table caption, optional; only between table start and table 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 ( ).
table end, required
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