Changing date format with Regex

[Terry Olsen]

I have a function that returns the date in the following format:

6/22/2005

I need the format to be:

050622

I have zero experience with RegEx but I believe that would be the way to go
here. Can someone give me some info on this? Or if RegEx isn't the way,
what would be the best method to re-format the date?

 

[Cor Ligthert]

Terry,

6/22/2005

Is that data a string as I assume or a real datetime (and than it is just a
datetime)

Cor

 

[Terry Olsen]

It is a string. It could be a datetime if I took the .ToString off the end.

 

[Cor Ligthert]

Terry,

Have a look of this page, it will give you the result probably.

http://msdn.microsoft.com/library/d...globalizationdatetimeformatinfoclasstopic.asp

(I don't know your culture settings therefore it is hard to give a good
sample).

If this helps not, than there are more possibilities.

I hope this helps,

Cor

 

[Armin Zingler]

It is a string. It could be a datetime if I took the .ToString off
the end.

If it's always this format:

Shared Function GetDate(ByVal s As String) As Date

Dim Parts As String()

Parts = s.Split("/"c)

Return New Date( _
Integer.Parse(Parts(2)), _
Integer.Parse(Parts(0)), _
Integer.Parse(Parts(1)) _
)

End Function

You might add some checks.

After converting to Date, uses the Date's ToString method to convert to any
format you want.

Armin

 

[Armin Zingler]

It is a string. It could be a datetime if I took the .ToString off
the end.

If it's always this format:

Shared Function GetDate(ByVal s As String) As Date

Dim Parts As String()

Parts = s.Split("/"c)

Return New Date( _
Integer.Parse(Parts(2)), _
Integer.Parse(Parts(0)), _
Integer.Parse(Parts(1)) _
)

End Function

You might add some checks.

After converting to Date, uses the Date's ToString method to convert to any
format you want.

Armin