convert date.today value

[slybitz]

Hello!

I am putting date.today into a variable called dte but I want to convert the date format from, for example, 12/10/2006 to 20061210. How can I do this? I know it's probably something simple but I can't seem to find the answer.

Thanks for your help!

 

[jebenson]

Assuming your date it mm/dd/yyyy:


Dim DateString As String

DateString = Year(dt).ToString & Month(dte).ToString & Day(dte).ToString

If you need leading zeroes on days and months that are less than 10 (e.g., 9/9/2006), then do this:

DateString = Year(dt).ToString

If Month(dte) < 10 Then
DateString &= "0" & Month(dte).ToString
Else
DateString &= Month(dte).ToString
End If

If Day(dte) < 10 Then
DateString &= "0" & Day(dte).ToString
Else
DateString &= Day(dte).ToString
End If

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day! Ye has a choice: talk like a pira

 

[ThatRickGuy]

Isn't that pretty close to MyDate.ToUniversalTime?

Or MyDate.format("yyyyMMdd")

or MyDate.year & format(mydate.month,"00") & format(mydate.day,"00")

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[slybitz]

Perfect, thank you!

 

[ThatRickGuy]

whoops. MyDate.format("yyyyMMdd") should be MyDate.ToString("yyyyMMdd")

It could also be done as Format(MyDate, "yyyyMMdd")

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.