About Formatted Expressions on Date Fields

This topic contains syntax suggestions and requirements for expressions on date fields, as well as details about how Meridium Enterprise 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 Meridium Enterprise 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.