Cultures & dates

[Jon]

I have an asp.net app that I've localized using satellite assemblies. It
works wonderfully, even for displaying dates. My problem comes when I try
to use one of those dates in a SQL query.

I have an SQL like "SELECT * FROM Table WHERE date < @Date"
I make a parameter for it as type SQLDBType.DateT ime. This works great for
US dates (12/31/04, for instance). But, the equivalent Frnech date
(31/12/04) throws an excption with the following error: "String was not
recognized as a valid DateTime."
So, I need to know how to convert the french date back to US format so the
SQL server doesn't puke. I'm sure there's a simple way to accomplish this,
but so far it's eluding me.

[Jon]

I had been using it all along, but for something different...
set the thread culture and execute the following and it will put it back to
US format....
Dim a As Date = DateTime.Parse( Me.txtDateTo.Te xt)

"Jon" <co****@columbu sinteractive.co m> wrote in message
news:1j******** **********@fe2. columbus.rr.com ...

I have an asp.net app that I've localized using satellite assemblies. It
works wonderfully, even for displaying dates. My problem comes when I try
to use one of those dates in a SQL query.

I have an SQL like "SELECT * FROM Table WHERE date < @Date"
I make a parameter for it as type SQLDBType.DateT ime. This works great
for US dates (12/31/04, for instance). But, the equivalent Frnech date
(31/12/04) throws an excption with the following error: "String was not
recognized as a valid DateTime."
So, I need to know how to convert the french date back to US format so the
SQL server doesn't puke. I'm sure there's a simple way to accomplish
this, but so far it's eluding me.

[Kevin Spencer]

Hmm, cultured Dates. I'd steer clear. They might be "bad" dates. Remember
"Raiders of the Lost Ark?' Hmmm?

--
;-),

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

"Jon" <co****@columbu sinteractive.co m> wrote in message
news:1j******** **********@fe2. columbus.rr.com ...

I have an asp.net app that I've localized using satellite assemblies. It
works wonderfully, even for displaying dates. My problem comes when I try
to use one of those dates in a SQL query.

I have an SQL like "SELECT * FROM Table WHERE date < @Date"
I make a parameter for it as type SQLDBType.DateT ime. This works great
for US dates (12/31/04, for instance). But, the equivalent Frnech date
(31/12/04) throws an excption with the following error: "String was not
recognized as a valid DateTime."
So, I need to know how to convert the french date back to US format so the
SQL server doesn't puke. I'm sure there's a simple way to accomplish
this, but so far it's eluding me.