US to UK Date?

Hi,

Trying to convert a Date from mm/dd/yyyy to dd/mm/yyyy using

Code:

---

    Public Function USToUKDate(ByRef USDate As String) As Date
        Dim Newdate() As String = USDate.Split("/")
        'Converts from US date format "01/20/2001" to UK 01/02/2013'
        Dim UKDate As String = Newdate(1) & "/" & Newdate(0) & "/" & Newdate(2)
        USToUKDate = CDate(UKDate)

---

Howver VB is throwing the following error

Quote:

---

Conversion from string "01/27/2010" to type 'Date' is not valid

---

Any ideas why?
Thanks

Have a look at this:


http://msdn.microsoft.com/en-us/libr...v=vs.110).aspx

Quote:

---

Originally Posted by .paul.

Have a look at this:


http://msdn.microsoft.com/en-us/libr...v=vs.110).aspx

---

Thanks

Something else I'd like to add... a date is a date... it has no format... so you shouldn't really care whether it is in US or UK or Marian format... because that's all it is ... a format... now, when you display the date, sure... then yes you care about the format... but only at display time.

-tg