Is "CDate" a bad thing to use?

[Owen]

It doesnt seem to always pick up the sysem date format properly, for example
if I do CDate("19/07/2005") it seems to return an error, even though my
Regional Settigns are dd/MM/yyyy. It seems to ignore the Regional Settings
and expect US date format everytime.

What is the reccomended alternative to CDate?

Thanks!
Owen

[Marina]

DateTime.Parse

"Owen" <sp**@spam.com> wrote in message
news:Cs*****************@newsfe1-win.ntli.net...

It doesnt seem to always pick up the sysem date format properly, for
example if I do CDate("19/07/2005") it seems to return an error, even
though my Regional Settigns are dd/MM/yyyy. It seems to ignore the
Regional Settings and expect US date format everytime.

What is the reccomended alternative to CDate?

Thanks!
Owen

[Armin Zingler]

"Owen" <sp**@spam.com> schrieb

It doesnt seem to always pick up the sysem date format properly, for
example if I do CDate("19/07/2005") it seems to return an error,
even though my Regional Settigns are dd/MM/yyyy. It seems to ignore
the Regional Settings and expect US date format everytime.

Maybe the seperator is set to "." instead of "/" in the regional settings?

What is the result of CDate? Is there an exception?
What is the reccomended alternative to CDate?

CDate is recommended, but you can also use Date.Parse.

Armin

[Ross Presser]

On Tue, 19 Jul 2005 13:44:02 GMT, Owen wrote:

It doesnt seem to always pick up the sysem date format properly, for example
if I do CDate("19/07/2005") it seems to return an error, even though my
Regional Settigns are dd/MM/yyyy. It seems to ignore the Regional Settings
and expect US date format everytime.

What is the reccomended alternative to CDate?

Thanks!
Owen

See the msdn help for DateTime.Parse() and DateTime.ParseExact().

[Owen]

"Armin Zingler" <az*******@freenet.de> wrote in message
news:eu**************@TK2MSFTNGP10.phx.gbl...

"Owen" <sp**@spam.com> schrieb

It doesnt seem to always pick up the sysem date format properly, for
example if I do CDate("19/07/2005") it seems to return an error,
even though my Regional Settigns are dd/MM/yyyy. It seems to ignore
the Regional Settings and expect US date format everytime.

Maybe the seperator is set to "." instead of "/" in the regional settings?

What is the result of CDate? Is there an exception?

Hi Armin, I get the following exception:

Cast from string "20/07/2005 09:02:33" to type 'Date' is not valid.

[Armin Zingler]

"Owen" <sp**@spam.com> schrieb

It doesnt seem to always pick up the sysem date format properly,
for example if I do CDate("19/07/2005") it seems to return an
error, even though my Regional Settigns are dd/MM/yyyy. It
seems to ignore the Regional Settings and expect US date format
everytime.

Maybe the seperator is set to "." instead of "/" in the regional
settings?

What is the result of CDate? Is there an exception?

Hi Armin, I get the following exception:

Cast from string "20/07/2005 09:02:33" to type 'Date' is not valid.

Sorry, I can't reproduce this using your regional settings. It works here.
Armin

[Owen]

"Armin Zingler" <az*******@freenet.de> wrote in message
news:uk**************@TK2MSFTNGP15.phx.gbl...

"Owen" <sp**@spam.com> schrieb

> > It doesnt seem to always pick up the sysem date format properly,
> > for example if I do CDate("19/07/2005") it seems to return an
> > error, even though my Regional Settigns are dd/MM/yyyy. It
> > seems to ignore the Regional Settings and expect US date format
> > everytime.
>
>
> Maybe the seperator is set to "." instead of "/" in the regional
> settings?
>
> What is the result of CDate? Is there an exception?

Hi Armin, I get the following exception:

Cast from string "20/07/2005 09:02:33" to type 'Date' is not valid.

Sorry, I can't reproduce this using your regional settings. It works here.

Not to worry.

I fixed the problem by editing my web.config to force the culture to "en-GB"
in the <globalization> section.
Owen