This topic contains syntax suggestions and requirements for expressions on date fields, as well as details about how GE Digital APM reformats expressions on date fields.
When you create an expression on a date field, you should use the following syntax:
(# :D 'yyyy-mm-dd')
Note: You will need to use the syntax yyyy-mm-dd on all workstations, regardless of your GE Digital APM Culture setting or your Windows Regional and Language options. Even if we input the date in the mm-dd-yyyy format, the expression should still use the yyyy-mm-dd format. However, always be sure to select the date in the expression, and then select the Date button. Selecting the Date button converts the date to yyyy-mm-dd format.
If you want to create an expression on the Asset Installation Date field to return the records where the field contains the value 05-04-2005 (where 05 represents May, and 04 represents the fourth day of the month), the expression would be:
WHERE [Asset].[ASSET INSL DT] = (# :D '2005-05-04')
Copyright © 2018 General Electric Company. All rights reserved.