Date in DatePicker

[Tengkorak]

i have problem when display date data from database to display on DatePicker.
the error is:
"Conversion from string "30/08/2011" to type 'Date' is not valid."

this vb code:

dtPO.Value = CDate(dtt.Rows(0).Item("po_date"))

data in database is "30/08/2011", not error if data "07/04/2011"

at other pc this can run well.

[marniel647]

i have problem when display date data from database to display on DatePicker.
the error is:
"Conversion from string "30/08/2011" to type 'Date' is not valid."

this vb code:

dtPO.Value = CDate(dtt.Rows(0).Item("po_date"))

data in database is "30/08/2011", not error if data "07/04/2011"

at other pc this can run well.

maybe the format is mm/dd/yyyy try to input 12/08/2011

[Tengkorak]

i tried modify code :

tPO.Value = CDate(String.Format("{0:mm/dd/yyyy}", (dtt.Rows(0).Item("po_date"))))

but same error

[marniel647]

i tried modify code :

tPO.Value = CDate(String.Format("{0:mm/dd/yyyy}", (dtt.Rows(0).Item("po_date"))))

but same error

try this :

tPO.Value = CDate(dtt.Rows(0).Item((String.Format"{0:mm/dd/yyyy}")"po_date")))

i dont think it's correct

[Tengkorak]

still can not

[jmcilhinney]

The error message says that it's trying to convert a String to a Date. Why do you have a String in the first place? If the data is dates then why aren't you storing it as Dates?

[Tengkorak]

at this code

dtPO.Value = CDate(dtt.Rows(0).Item("po_date"))

i tried covert string to date type

[Tengkorak]

the big question for me is, why an error occurs when I open my program it from another pc. whereas if I use the other pc no problem.
whether this is related with the regional settings in windows or whether ?

[jmcilhinney]

It is related to regional settings. CDate assumes that a String is in the appropriate format based on regional settings. On a system where a format like dd/MM/yyyy is used, "30/08/2011" will be converted to August 30, 2011. On a system where a format like MM/dd/yyyy is used, that String doesn't represent a valid date. If you want to convert a String into a Date using a specific format regardless of regional settings, you should use Date.ParseExact or, if you're not 100% sure the String is valid, Date.TryParseExact.

Of course, if you stored the data as Dates instead of Strings, there'd be no conversions performed so format would never be an issue. If you have no choice but to use Strings because this is an existing database or some other reason, use ParseExact or TryParseExact. If it's within your power to change the database schema, do so. If you do it right in the first place, you don't have to worry about fixes later.

[Tengkorak]

thank you, very helpful