Difference between revisions of "Date Expressions"

From Keyfax Wiki
Jump to: navigation, search
Line 7: Line 7:
 
|} table end, required
 
|} table end, required
  
{|
+
{| class="wikitable"
 
|+ As Date Expressions
 
|+ As Date Expressions
 
!Expression
 
!Expression

Revision as of 11:20, 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