Date: Thu, 28 Mar 2024 16:34:04 +0200 (EET) Message-ID: <1552704753.1017.1711636444445@wiki.vertuna.com> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_1016_1134130842.1711636444383" ------=_Part_1016_1134130842.1711636444383 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Text masks are generally configured using the following format: 00/00/00= 00, where 0 shows a place that will be replaced by actual value. Below, you= can see some examples. Of course, you can construct your own.
What character can be used in a mask, and what character is accepted as = input
Mask | Example | Comment |
00/00/0000 | 23/12/2014 | used for dates |
00.00.0000 | 23.12.2014 | used for dates |
000.000.000.000.000,00 | 1.000,23 | used for money |
00/00/0000 00:00:00 | 23/12/2014 10:12:13 | used for date time |
00/00/0000 00:00:00 | 23/12/2014 10:12:13 | used for date time |
##0,00% | 23% | used for percent |
AAA 000-S0S | xyz 456-e2f | complex |
Another advance feature when you use masks (in 'Masked Text' field) is a= bility to configure it's type and teach it how the input can be converted w= hen used with filters, for example.
Here is a basic example on how to use 'Masked Text' field and have it as= a date type field.
Now the field's value can be converted to date and used as date value wh= en querying, as pattern tells the field about back conversion.
Pattern uses the format used by Java's SimpleDateFormat (for dates) and DecimalFormat (for numbers)