Brian Bermingham
|
| Posted: 04/24/2002, 10:51 AM |
|
In the project properties the only options for default dates are in US
format mm/dd/yy
Will there be an option for dd/mm/yy ?
I'm sure I'm not alone in not living in the US!
|
|
|
 |
Oleg Dudko
|
| Posted: 04/24/2002, 10:57 AM |
|
Brian,
> In the project properties the only options for default dates are in US
> format mm/dd/yy
> Will there be an option for dd/mm/yy ?
> I'm sure I'm not alone in not living in the US!
Yes, of course you can enter manually any of formats, including "dd/mm/yy".
Let me know if you have any problems.
Full Date Format description is below.
Thanks,
Oleg
Setting Description
GeneralDate This format depends from regional settings.
If the value is a date only, no time is displayed; if the value is a
time only, no date is displayed. This setting is a combination of the Short
Date and Long Time settings.
Examples: 4/3/93, 05:34:00 PM, and 4/3/93 05:34:00 PM.
LongDate This format depends from regional settings.
Example: Saturday, April 3, 1993.
ShortDate This format depends from regional settings.
Example: 4/3/93.
Warning: The Short Date setting assumes that dates between 1/1/00 and
12/31/29 are twenty-first century dates (that is, the years are assumed to
be 2000 to 2029). Dates between 1/1/30 and 12/31/99 are assumed to be
twentieth century dates (that is, the years are assumed to be 1930 to 1999).
LongTime This format depends from regional settings.
Example: 5:34:23 PM.
ShortTime This format depends from regional settings.
Example: 17:34.
Warning: Predefined Formats are valid only for languages which have the
ability to formatting the date in corresponding of the current LCID (ASP,
Java). In the other languages this formats will be equal to the standard US
Date/Time formats.
Custom Formats
You can create custom date and time formats by using the following symbols.
Symbol Description
d Day of the month in one or two numeric digits, as needed (1 to 31).
dd Day of the month in two numeric digits (01 to 31).
ddd First three letters of the weekday (Sun to Sat).
dddd Full name of the weekday (Sunday to Saturday).
w Day of the week (1 to 7).
m Month of the year in one or two numeric digits, as needed (1 to 12).
mm Month of the year in two numeric digits (01 to 12).
mmm First three letters of the month (Jan to Dec).
mmmm Full name of the month (January to December).
q Date displayed as the quarter of the year (1 to 4).
yy Last two digits of the year (01 to 99).
yyyy Full year (0100 to 9999).
h 12-hour format without leading zeros (1 to 12).
hh 12-hour format with leading zeros (01 to 12).
H Hour in one or two digits, as needed (0 to 23).
HH Hour in two digits (0 to 23).
n Minute in one or two digits, as needed (0 to 59).
nn Minute in two digits (00 to 59).
s Second in one or two digits, as needed (0 to 59).
ss Second in two digits (00 to 59).
AM/PM Twelve-hour clock with the uppercase letters "AM" or "PM", as
appropriate.
am/pm Twelve-hour clock with the lowercase letters "am" or "pm", as
appropriate.
A/P Twelve-hour clock with the uppercase letter "A" or "P", as
appropriate.
a/p Twelve-hour clock with the lowercase letter "a" or "p", as
appropriate.
Example
The following are examples of custom date/time formats. Setting Display
ddd, mmm d, yyyy Mon, Jun 2, 1997
mmmm dd, yyyy June 02, 1997
dddd Tuesday
|
|
|
|
Oleg Dudko
|
| Posted: 04/24/2002, 11:02 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0056_01C1EBD3.6DC41B80
Content-Type: text/plain;
charset="koi8-r"
Content-Transfer-Encoding: quoted-printable
Full Date Format description below is in HTML (I hope 
Setting Description=20
GeneralDate This format depends from regional settings.=20
If the value is a date only, no time is displayed; if the value is =
a time only, no date is displayed. This setting is a combination of the =
Short Date and Long Time settings.=20
Examples: 4/3/93, 05:34:00 PM, and 4/3/93 05:34:00 PM.
=20
LongDate This format depends from regional settings.=20
Example: Saturday, April 3, 1993.
=20
ShortDate This format depends from regional settings.=20
Example: 4/3/93.
Warning: The Short Date setting assumes that dates between 1/1/00 =
and 12/31/29 are twenty-first century dates (that is, the years are =
assumed to be 2000 to 2029). Dates between 1/1/30 and 12/31/99 are =
assumed to be twentieth century dates (that is, the years are assumed to =
be 1930 to 1999).
=20
LongTime This format depends from regional settings.=20
Example: 5:34:23 PM.
=20
ShortTime This format depends from regional settings.=20
Example: 17:34.
=20
Warning: Predefined Formats are valid only for languages which have the =
ability to formatting the date in corresponding of the current LCID =
(ASP, Java). In the other languages this formats will be equal to the =
standard US Date/Time formats.=20
Custom Formats
You can create custom date and time formats by using the following =
symbols. Symbol Description=20
d Day of the month in one or two numeric digits, as needed (1 to =
31).=20
dd Day of the month in two numeric digits (01 to 31).=20
ddd First three letters of the weekday (Sun to Sat).=20
dddd Full name of the weekday (Sunday to Saturday).=20
w Day of the week (1 to 7).=20
m Month of the year in one or two numeric digits, as needed (1 to =
12).=20
mm Month of the year in two numeric digits (01 to 12).=20
mmm First three letters of the month (Jan to Dec).=20
mmmm Full name of the month (January to December).=20
q Date displayed as the quarter of the year (1 to 4).=20
yy Last two digits of the year (01 to 99).=20
yyyy Full year (0100 to 9999).=20
h 12-hour format without leading zeros (1 to 12).=20
hh 12-hour format with leading zeros (01 to 12).=20
H Hour in one or two digits, as needed (0 to 23).=20
HH Hour in two digits (0 to 23).=20
n Minute in one or two digits, as needed (0 to 59).=20
nn Minute in two digits (00 to 59).=20
s Second in one or two digits, as needed (0 to 59).=20
ss Second in two digits (00 to 59).=20
AM/PM Twelve-hour clock with the uppercase letters "AM" or "PM", =
as appropriate.=20
am/pm Twelve-hour clock with the lowercase letters "am" or "pm", =
as appropriate.=20
A/P Twelve-hour clock with the uppercase letter "A" or "P", as =
appropriate.=20
a/p Twelve-hour clock with the lowercase letter "a" or "p", as =
appropriate.=20
Example
The following are examples of custom date/time formats. Setting Display=20
ddd, mmm d, yyyy Mon, Jun 2, 1997=20
mmmm dd, yyyy June 02, 1997=20
dddd Tuesday=20
------=_NextPart_000_0056_01C1EBD3.6DC41B80
Content-Type: text/html;
charset="koi8-r"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dkoi8-r">
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>Full Date Format description below is =
in HTML (I=20
hope </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>
<TABLE>
<TBODY>
<TR>
<TH width=3D"15%">Setting</TH>
<TH>Description</TH></TR>
<TR>
<TD>GeneralDate</TD>
<TD>This format depends from regional settings. <BR>If the value is =
a date=20
only, no time is displayed; if the value is a time only, no date =
is=20
displayed. This setting is a combination of the Short Date and =
Long Time=20
settings.=20
<P>Examples: 4/3/93, 05:34:00 PM, and 4/3/93 05:34:00 =
PM.</P></TD></TR>
<TR>
<TD>LongDate</TD>
<TD>This format depends from regional settings.=20
<P>Example: Saturday, April 3, 1993.</P></TD></TR>
<TR>
<TD>ShortDate</TD>
<TD>This format depends from regional settings.=20
<P>Example: 4/3/93.</P>
<P><B>Warning:</B> The Short Date setting assumes that dates =
between=20
1/1/00 and 12/31/29 are twenty-first century dates (that is, the =
years are=20
assumed to be 2000 to 2029). Dates between 1/1/30 and 12/31/99 are =
assumed=20
to be twentieth century dates (that is, the years are assumed to =
be 1930=20
to 1999).</P></TD></TR>
<TR>
<TD>LongTime</TD>
<TD>This format depends from regional settings.=20
<P>Example: 5:34:23 PM.</P></TD></TR>
<TR>
<TD>ShortTime</TD>
<TD>This format depends from regional settings.=20
<P>Example: =
17:34.</P></TD></TR></TBODY></TABLE><BR><B>Warning:</B> Predefined=20
Formats are valid only for languages which have the ability to =
formatting the=20
date in corresponding of the current LCID (ASP, Java). In the other =
languages=20
this formats will be equal to the standard US Date/Time formats.=20
<H2>Custom Formats</H2>You can create custom date and time formats by =
using the=20
following symbols.=20
<TABLE>
<TBODY>
<TR>
<TH width=3D"15%">Symbol</TH>
<TH>Description</TH></TR>
<TR>
<TD>d</TD>
<TD>Day of the month in one or two numeric digits, as needed (1 to=20
31).</TD></TR>
<TR>
<TD>dd</TD>
<TD>Day of the month in two numeric digits (01 to 31).</TD></TR>
<TR>
<TD>ddd</TD>
<TD>First three letters of the weekday (Sun to Sat).</TD></TR>
<TR>
<TD>dddd</TD>
<TD>Full name of the weekday (Sunday to Saturday).</TD></TR>
<TR>
<TD>w</TD>
<TD>Day of the week (1 to 7).</TD></TR>
<TR>
<TD>m</TD>
<TD>Month of the year in one or two numeric digits, as needed (1 to=20
12).</TD></TR>
<TR>
<TD>mm</TD>
<TD>Month of the year in two numeric digits (01 to 12).</TD></TR>
<TR>
<TD>mmm</TD>
<TD>First three letters of the month (Jan to Dec).</TD></TR>
<TR>
<TD>mmmm</TD>
<TD>Full name of the month (January to December).</TD></TR>
<TR>
<TD>q</TD>
<TD>Date displayed as the quarter of the year (1 to 4).</TD></TR>
<TR>
<TD>yy</TD>
<TD>Last two digits of the year (01 to 99).</TD></TR>
<TR>
<TD>yyyy</TD>
<TD>Full year (0100 to 9999).</TD></TR>
<TR>
<TD>h</TD>
<TD>12-hour format without leading zeros (1 to 12).</TD></TR>
<TR>
<TD>hh</TD>
<TD>12-hour format with leading zeros (01 to 12).</TD></TR>
<TR>
<TD>H</TD>
<TD>Hour in one or two digits, as needed (0 to 23).</TD></TR>
<TR>
<TD>HH</TD>
<TD>Hour in two digits (0 to 23).</TD></TR>
<TR>
<TD>n</TD>
<TD>Minute in one or two digits, as needed (0 to 59).</TD></TR>
<TR>
<TD>nn</TD>
<TD>Minute in two digits (00 to 59).</TD></TR>
<TR>
<TD>s</TD>
<TD>Second in one or two digits, as needed (0 to 59).</TD></TR>
<TR>
<TD>ss</TD>
<TD>Second in two digits (00 to 59).</TD></TR>
<TR>
<TD>AM/PM</TD>
<TD>Twelve-hour clock with the uppercase letters "AM" or "PM", as=20
appropriate.</TD></TR>
<TR>
<TD>am/pm</TD>
<TD>Twelve-hour clock with the lowercase letters "am" or "pm", as=20
appropriate.</TD></TR>
<TR>
<TD>A/P</TD>
<TD>Twelve-hour clock with the uppercase letter "A" or "P", as=20
appropriate.</TD></TR>
<TR>
<TD>a/p</TD>
<TD>Twelve-hour clock with the lowercase letter "a" or "p", as=20
appropriate.</TD></TR></TBODY></TABLE><BR><!--=20
Custom formats are displayed according to the settings specified in the =
<B class=3D"UI" name=3D"regionalsettingsproperties">Regional Settings =
Properties</b> dialog box in Windows Control Panel. Custom formats =
inconsistent with the settings specified in the <B class=3D"UI" =
name=3D"regionalsettingsproperties">Regional Settings Properties</b> =
dialog box are ignored.</p>
<p class=3DNT><B>Note</b> If you want to add a comma or =
other separator to your custom format, enclose the separator in =
quotation marks like this: mmm d", "yyyy.</p>
-->
<H2><A name=3D#example></A>Example</H2>The following are examples of =
custom=20
date/time formats.=20
<TABLE>
<TBODY>
<TR>
<TH>Setting</TH>
<TH>Display</TH></TR>
<TR>
<TD>ddd, mmm d, yyyy</TD>
<TD>Mon, Jun 2, 1997</TD></TR>
<TR>
<TD>mmmm dd, yyyy</TD>
<TD>June 02, 1997</TD></TR>
<TR>
<TD>dddd</TD>
<TD>Tuesday</TD></TR></TBODY></TABLE><!-- BR>
You could use a custom format to display "A.D." before or "B.C." after a =
year depending on whether a positive or negative number is entered. To =
see this custom format work, create a new table field, set its data type =
to Number and enter a format as follows:
<br>
"A.D. " #;# " B.C."
<br>
Positive numbers are displayed as years with an "A.D." before the year. =
Negative numbers are displayed as years with a "B.C." after the year. =
--></FONT></DIV></BODY></HTML>
------=_NextPart_000_0056_01C1EBD3.6DC41B80--
|
|
|
|
Brian Bermingham
|
| Posted: 04/24/2002, 12:54 PM |
|
Thanks Oleg
I manually entered the date format on my second attempt.
The first time I tried CCs crashed.
I just thought it would be nice to have some none US formats to choose from
in the predefined formats!
"Oleg Dudko" <oleg.dudko@yessoftware.com> wrote in message
news:aa6rlk$k97$1@news.codecharge.com...
> Brian,
>
> > In the project properties the only options for default dates are in US
> > format mm/dd/yy
> > Will there be an option for dd/mm/yy ?
> > I'm sure I'm not alone in not living in the US!
>
> Yes, of course you can enter manually any of formats, including
"dd/mm/yy".
> Let me know if you have any problems.
>
> Full Date Format description is below.
>
> Thanks,
> Oleg
>
> Setting Description
> GeneralDate This format depends from regional settings.
> If the value is a date only, no time is displayed; if the value is a
> time only, no date is displayed. This setting is a combination of the
Short
> Date and Long Time settings.
> Examples: 4/3/93, 05:34:00 PM, and 4/3/93 05:34:00 PM.
>
> LongDate This format depends from regional settings.
> Example: Saturday, April 3, 1993.
>
> ShortDate This format depends from regional settings.
> Example: 4/3/93.
>
> Warning: The Short Date setting assumes that dates between 1/1/00
and
> 12/31/29 are twenty-first century dates (that is, the years are assumed to
> be 2000 to 2029). Dates between 1/1/30 and 12/31/99 are assumed to be
> twentieth century dates (that is, the years are assumed to be 1930 to
1999).
>
> LongTime This format depends from regional settings.
> Example: 5:34:23 PM.
>
> ShortTime This format depends from regional settings.
> Example: 17:34.
>
>
> Warning: Predefined Formats are valid only for languages which have the
> ability to formatting the date in corresponding of the current LCID (ASP,
> Java). In the other languages this formats will be equal to the standard
US
> Date/Time formats.
> Custom Formats
> You can create custom date and time formats by using the following
symbols.
> Symbol Description
> d Day of the month in one or two numeric digits, as needed (1 to
31).
> dd Day of the month in two numeric digits (01 to 31).
> ddd First three letters of the weekday (Sun to Sat).
> dddd Full name of the weekday (Sunday to Saturday).
> w Day of the week (1 to 7).
> m Month of the year in one or two numeric digits, as needed (1 to
12).
> mm Month of the year in two numeric digits (01 to 12).
> mmm First three letters of the month (Jan to Dec).
> mmmm Full name of the month (January to December).
> q Date displayed as the quarter of the year (1 to 4).
> yy Last two digits of the year (01 to 99).
> yyyy Full year (0100 to 9999).
> h 12-hour format without leading zeros (1 to 12).
> hh 12-hour format with leading zeros (01 to 12).
> H Hour in one or two digits, as needed (0 to 23).
> HH Hour in two digits (0 to 23).
> n Minute in one or two digits, as needed (0 to 59).
> nn Minute in two digits (00 to 59).
> s Second in one or two digits, as needed (0 to 59).
> ss Second in two digits (00 to 59).
> AM/PM Twelve-hour clock with the uppercase letters "AM" or "PM", as
> appropriate.
> am/pm Twelve-hour clock with the lowercase letters "am" or "pm", as
> appropriate.
> A/P Twelve-hour clock with the uppercase letter "A" or "P", as
> appropriate.
> a/p Twelve-hour clock with the lowercase letter "a" or "p", as
> appropriate.
>
>
> Example
> The following are examples of custom date/time formats. Setting Display
> ddd, mmm d, yyyy Mon, Jun 2, 1997
> mmmm dd, yyyy June 02, 1997
> dddd Tuesday
>
>
>
|
|
|
|
Oleg Dudko
|
| Posted: 04/24/2002, 2:02 PM |
|
Your request was submitted
> I just thought it would be nice to have some none US formats to choose
from
> in the predefined formats!
|
|
|
|
|
