Date format and regional settings
| Author |
Message |
|
Yoram Accr
#1 / 7
|
 Date format and regional settings I want to format dates as MMM, dd, YYYY in ENGLISH! My regional settings are set for Israel, which means that I normally get the dates in a Hebrew text. Is it possible to get a date in English without changing the regional
settings?
TIA,
Yoram
|
| Fri, 11 Oct 2002 03:00:00 GMT |
|
 |
|
Simon Lewi
#2 / 7
|
Date format and regional settings Yoram, Use the Format function:
Format(dtmYourDate, "MMM, dd, YYYY")
Simon Lewis
Quote: > I want to format dates as MMM, dd, YYYY in ENGLISH! > My regional settings are set for Israel, which means that I normally get the > dates in a Hebrew text. > Is it possible to get a date in English without changing the regional
> settings?
> TIA,
> Yoram
|
| Sat, 12 Oct 2002 03:00:00 GMT |
|
|
|
Yoram Accr
#3 / 7
|
Date format and regional settings I need the date in ENGLISH and my regional settings are set for Israel's time zone. Using only the Format function the current date is: ??,27,2000 (probably you can't read the above probably) and I want the month displayed in ENGLISH!!! Yoram
Quote: > Yoram, > Use the Format function:
> Format(dtmYourDate, "MMM, dd, YYYY")
> Simon Lewis
> > I want to format dates as MMM, dd, YYYY in ENGLISH!
> > My regional settings are set for Israel, which means that I normally get
> the
> > dates in a Hebrew text.
> > Is it possible to get a date in English without changing the regional
> > settings?
> > TIA,
> > Yoram
|
| Mon, 14 Oct 2002 03:00:00 GMT |
|
|
|
michk
#4 / 7
|
Date format and regional settings To get the month displayed in English, you cannot use VBA's default functions. However, you can use the code on my site (link below), on the code samples
page, looking at the "basIntlFormats" module....it includes a replacement
for the FormatDateTime function that allows to specify a locale so that you
can get the string for 1033 (the LCID for US English) even when the control
panel is using 1037 (Hebrew).
--
MichKa
"Cause it's a bittersweet symphony, thats life..." -- The Verve
random junk of dubious value, at the multilingual,
no scripts required, http://www.trigeminal.com/
Quote: > I need the date in ENGLISH and my regional settings are set for Israel's > time zone. > Using only the Format function the current date is: > ??,27,2000 > (probably you can't read the above probably) > and I want the month displayed in ENGLISH!!! > Yoram
> > Yoram,
> > Use the Format function:
> > Format(dtmYourDate, "MMM, dd, YYYY")
> > Simon Lewis
> > > I want to format dates as MMM, dd, YYYY in ENGLISH!
> > > My regional settings are set for Israel, which means that I normally
get
> > the
> > > dates in a Hebrew text.
> > > Is it possible to get a date in English without changing the regional
> > > settings?
> > > TIA,
> > > Yoram
|
| Mon, 14 Oct 2002 03:00:00 GMT |
|
|
|
Yoram Accr
#5 / 7
|
Date format and regional settings Thanks Michael, That's exactly what I need.
You also have a nice site.
Yoram
Quote: > To get the month displayed in English, you cannot use VBA's default > functions. > However, you can use the code on my site (link below), on the code samples
> page, looking at the "basIntlFormats" module....it includes a replacement
> for the FormatDateTime function that allows to specify a locale so that
you
> can get the string for 1033 (the LCID for US English) even when the
control
> panel is using 1037 (Hebrew).
> --
> MichKa
> "Cause it's a bittersweet symphony, thats life..." -- The Verve
> random junk of dubious value, at the multilingual,
> no scripts required, http://www.trigeminal.com/
> > I need the date in ENGLISH and my regional settings are set for Israel's
> > time zone.
> > Using only the Format function the current date is:
> > ??,27,2000
> > (probably you can't read the above probably)
> > and I want the month displayed in ENGLISH!!!
> > Yoram
> > > Yoram,
> > > Use the Format function:
> > > Format(dtmYourDate, "MMM, dd, YYYY")
> > > Simon Lewis
> > > > I want to format dates as MMM, dd, YYYY in ENGLISH!
> > > > My regional settings are set for Israel, which means that I normally
> get
> > > the
> > > > dates in a Hebrew text.
> > > > Is it possible to get a date in English without changing the
regional
> > > > settings?
> > > > TIA,
> > > > Yoram
|
| Mon, 14 Oct 2002 03:00:00 GMT |
|
| |
|
