US to UK Date?

[brilldoctor]

Hi,

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

    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

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

Any ideas why?
Thanks

[.paul.]

Have a look at this:


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

[brilldoctor]

Have a look at this:


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

Thanks

[techgnome]

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