Hi Manfred,
Thank you for the welcome, this is very new to me and its nice to meet helpful people.
As I understand, my date is not in the right format so needs to be changed before it can be parsed.
Dim oldDateformat = DateTime.DateFormat
DateTime.DateFormat = "dd/MM/yyyy"
Dim sDate As String = "25/12/2014" 'String Date
Dim lngDate As Long = DateTime.DateParse(sDate) 'Convert String to Long with Date Parse
DateTime.DateFormat = "dd MMM yyyy" 'Format Date
Log("Tag: "&DateTime.Date(lngDate))
DateTime.DateFormat = oldDateformat
This is what I tried but still with no luck, it threw an error on java.lang.NumberFormatException: Invalid double: "MM/dd/yyyy"
Hope you can help further.
Jonathan