The Formatted Equals operator will allow dates and numbers to have format masks applied to them before and after they have been compared. See the tables below for available options:
Supported Date Symbols#
| Letter | Date or Time Component | Presentation | Examples |
|---|---|---|---|
| G | Era designator | Text | AD |
| Y | Year | Year | 1996; 96 |
| M | Month in year | Month | July; Jul; 07 |
| W | Week in year | Number | 27 |
| W | Week in month | Number | 2 |
| D | Day in year | Number | 189 |
| d | Day in month | Number | 10 |
| F | Day of week in month | Number | 2 |
| E | Day in week | Text | Tuesday; Tue |
| a | AM/PM marker | Text | PM |
| H | Hour in day (0-23) | Number | 0 |
| k | Hour in day (1-24) | Number | 24 |
| K | Hour in AM/PM (0-11) | Number | 0 |
| h | Hour in AM/PM (1-12) | Number | 12 |
| m | Minute in hour | Number | 30 |
| s | Second in minute | Number | 55 |
| S | Millisecond | Number | 978 |
| z | Time zone | General time zone | Pacific Standard Time; PST; GMT-08:00 |
| Z | Time zone | RFC 822 time zone | -0800 |
Supported Number Symbols#
| Symbol | Location | Localized? | Meaning |
|---|---|---|---|
| 0 | Number | Yes | Digit |
| # | Number | Yes | Digit, zero shows absent |
| . | Number | Yes | Decimal separator or monetary decimal separator |
| - | Number | Yes | Minus sign |
| , | Number | Yes | Grouping separator |
| E | Number | Yes | Separates mantissa and exponent in scientific notation. Need not be quoted in prefix or suffix. |
| ; | Sub pattern boundary | Yes | Separates positive and negative sub patterns |
| % | Prefix or suffix | Yes | Multiply by 100 and show as percentage |
| \u2030 | Prefix or suffix | Yes | Multiply by 1000 and show as per mille value |
| ¤ (\u00A4) | Prefix or suffix | No | Currency sign, replaced by currency symbol. If doubled, replaced by international currency symbol. If present in a pattern, the monetary decimal separator is used instead of the decimal separator. |
| ‘ | Prefix or suffix | No | Used to quote special characters in a prefix or suffix, for example, “ ’ # ’ # “ formats 123 to “#123”. To create a single quote itself, use two in a row: “# 0’ ‘ clock”. |
Using the Formatted Equals operator, clients can adjust Date Values by adding or subtracting from the parameterized date using the following symbols:
- D Day
- M Month
- Y Year
These can be combined and should be prefixed with either a + (Add) or – (Subtract) symbol.
If users need to add or subtract days, months or years, the mathematical equation needs to be entered in the Value field as the specified format is applied to both sides of the equation. If users do not include D, M, or Y the system assumes D. For example, <<AS_Of_DATE>> +365, would result 31-Jul- 2009 (where the as of date is 31-Jul-2008).
