The following masks should be supported for input fields
for text fields
! = UpperCase Any alphabet entered in lower case will be automatically converted into uppercase
^ = LowerCase Any alphabet entered in upper case will be automatically converted into Lowercase
# = number ( 0-9 + -)
a = Alphanumeric character
x = any character
e.g (ax#^!)###
for date fields
###-##-####
- -
dd = Day of Month
mm = Month number
yy = year
yyyy Century and year
iii = julian day
mmm = month abbreviation (e.g mar for March)
[date] = international date format ( as per windows regional settings for sshortdate )
dd-mm-yyyy
mm-dd-yy
dd/mm/yyyy
for currency
RIGHT JUSTIFIED
[currency(10)]
regional currency settiongs from registry with max 10 digit including decimals excluding currency symbol, commas,decimal point
00000000.00
123 = 00000123.00
123.01 = 00000123.01
RIGHT JUSTIFIED prefix & POSTFIX zeros for any number INCLUDING DECIMAL VALUES
##############.##
1.10 = 1.1
0123.12 = 123.12
RIGHT JUSTIFIED SUPRESS LEADING ZEROS FOR NUMBER AND TRAILING ZEROS FOR DECIMAL VALUES
for dates
hh:mm:ss:fff
hh = hour
mm = minutes
ss = seconds
fff = fraction seconds