Difference between revisions of "Date Expressions"

From Keyfax Wiki
Jump to: navigation, search
Line 9: Line 9:
 
{|
 
{|
 
|+ As Date Expressions
 
|+ As Date Expressions
|Expression
+
!Expression
|Databox Value
+
!Databox Value
|Result
+
!Result
|Comments
+
!Comments
 
|-
 
|-
 
|AsDate
 
|AsDate

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