Note: A monetary sign must always be present in the value when
working with currencies. If there is not a default setting, then you
must enter a number and the monetary sign.
Date The Date property can be set in any of six different formats.
They are grouped into two major format types:
Full Date formats - This setting forces you to set a date
which consists of a two-number day, two-number month,
and four-number year. You will always obtain a date that
fits this format if you use the required quantity of numbers.
For example, if the enter the month of February, then you
must be enter 02 instead of 2. Therefore, February 7th,
2001 could be entered as 02/07/2001.
Short Date formats - Using this setting the date will consist
of either a one-number or two-number day and a one-num-
ber or two-number month. A two-number year will always
be required. This means that zero (0) will not be used as
the first number for month or day. For example, the month
of February should be represented as 2 (not as 02);
however, zero will be accepted as the first number of a year.
This means that you may enter 2001 as 01. Therefore,
February 7th, 2001 could be entered as 2/7/01.
Each of the previously discussed sets have three seperate formats.
They are:
month/day/year (represented in the palette as 03/29/1999
and 3/29/99 respectively)
day/month/year (represented in the palette as 29/03/1999
and 29/3/99 respectively)
year/month/day (represented in the palette as 1999/03/29
and 99/3/29 respectively)
You can use the forward-slash (/) to seperate the month, day, and
year; however, typing the forward-slash is not required. For example,
you may enter a the following string of numbers, 03291999, and
Canvas will automatically separate them and create string value 03/
29/1999 as long as it conforms to the format. However, you should
be aware that a confusing situation can occur when using short date
formats. For example, if you wish to enter a date of January 23rd,
1999, and expect it to appear as 1/23/99, you must enter at least one
forward-slash character in the string so that Canvas can resolve the
entry. In our example, typing the entry as 12399 will resolve entry
as 12/3/99. In such acase at least one forward-slash character (/)