From String to correct DateTime

So, I'm trying to do this...
DatumRodjenja_db = DatumRodjenja.Substring(6, 4) & "-" & DatumRodjenja.Substring(3, 2) & "-" & DatumRodjenja.Substring(0, 2)

Where DatumRodjenja_db is DateTime variable, and DatumRodjenja is String. And even after that, I'm still getting DatumRodjenja_db in this format "DD.MM.YYYY."

The thing is I need date in "YYYY-MM-DD" format because that's how I store it into database.

I suppose this is some kind of problem in CultureInfo but still I can't figure it out...thank you.

re: From String to correct DateTime

you will format date in mm/dd/yyyy format and then enter

re: From String to correct DateTime

Can you explain me how? Because everything I've tried a lot of stuff and didn't find the solution.
thanks

re: From String to correct DateTime

Use the DateTime's ToString method. Supply the ToString method with a "format string" that specifies how the string should be printed.

Check this out. It gives you a listing of standard date/time format strings.

-Frinny

re: From String to correct DateTime

cdate(yourdate).tostring("yyyy/MM/dd")