MMddyy to yyyymmdd

default23 · #1 (**permalink**) March 28th, 2012, 02:18 AM

Hi
is there a way to convert MMddyyyy to yyyymmdd , stored in a text file
using vb.net

Any ideas are welcome
regards

disel2010 · #2 (**permalink**) March 29th, 2012, 03:05 AM

Hi,

just parse the string to date and use the toString with a specific DateFormat afterwards.

There are actually hundred ways to do this, in one way it could look like this:

Code:

 
         Public Function CustomConversion(dateString as String) As String
         	Dim dateFormatIn, dateFormatOut As String  
         	Dim myDate As Date

         	dateFormatIn = "MMddyyyy"
         	dateFormatOut = "yyyyMMdd" 
         	
         	myDate = Date.ParseExact(dateString, dateFormatIn, provider)
         	return myDate.ToString(dateFormatOut) 
         	
         End Function

You probably want to make it a bit safer by using TryParseExact etcetera but you get the idea..

Success !

default23 · #3 (**permalink**) March 29th, 2012, 03:52 AM

Quote:

Originally Posted by disel2010

Hi,

just parse the string to date and use the toString with a specific DateFormat afterwards.

There are actually hundred ways to do this, in one way it could look like this:

Code:

 
         Public Function CustomConversion(dateString as String) As String
         	Dim dateFormatIn, dateFormatOut As String  
         	Dim myDate As Date

         	dateFormatIn = "MMddyyyy"
         	dateFormatOut = "yyyyMMdd" 
         	
         	myDate = Date.ParseExact(dateString, dateFormatIn, provider)
         	return myDate.ToString(dateFormatOut) 
         	
         End Function

You probably want to make it a bit safer by using TryParseExact etcetera but you get the idea..

Success !

Hi

can you tell me how to open the file here like
Public Function CustomConversion(dateString as String) As String
Dim dateFormatIn, dateFormatOut As String
Dim myDate As Date ' where can i put the code open file C:\dates.txt

dateFormatIn = "MMddyyyy"
dateFormatOut = "yyyyMMdd"

myDate = Date.ParseExact(dateString, dateFormatIn, provider)
return myDate.ToString(dateFormatOut)

End Function

Need to download code?

Navigation