DateString convert

[simon]

I would like to get the string in this format: yyyyddmm , like in sql.

I read the date from the calendarControl:

dateString=Calendar.SelectedDate.Date.ToShortDateS tring

and I get dateString=4.12.2003

I would like to have:dateString=12042003

What is the best way to do that?

Thank you,

Simon

[Hakan Gok]

Try the following code: y=year, M=month, d=day

Dim strDate as String = Format(DateTime.Now, "yyyyMMdd")

[Phill. W]

"simon" <si*********@stud-moderna.si> wrote in message
news:uC**************@TK2MSFTNGP10.phx.gbl...

I would like to get the string in this format: yyyyddmm , like in sql.
SQL does not have a date format.
It can apply formatting to values as they are returned to you but,
internally, the database can store the data any way it darn well
pleases (and it'll be nothing like anything you or I can make sense
of).
I read the date from the calendarControl:
dateString=Calendar.SelectedDate.Date.ToShortDateS tring
and I get dateString=4.12.2003

which is exactly what you asked for.

If you want a /specific/ format, then format the Date the way
you want it to be, as in

dateString = Calendar.SelectedDate.Date.ToString( "ddMMyyyy" )

Bear in mind that VB will have a Devil of time trying to turn this
eight-digit number back into a Date, if you ever ask it to...

HTH,
Phill W.

[Herfried K. Wagner [MVP]]

* "simon" <si*********@stud-moderna.si> scripsit:

I would like to get the string in this format: yyyyddmm , like in sql.

I read the date from the calendarControl:

dateString=Calendar.SelectedDate.Date.ToShortDateS tring

'<...>.Date.ToString(<format>)'.

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

[Armin Zingler]

"simon" <si*********@stud-moderna.si> schrieb

I would like to get the string in this format: yyyyddmm , like in
sql.

I read the date from the calendarControl:

dateString=Calendar.SelectedDate.Date.ToShortDateS tring

and I get dateString=4.12.2003

I would like to have:dateString=12042003

What is the best way to do that?

Use the Date's ToString method instead of ToShortDateString. You can pass
the needed format to ToString.
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[Mike Labosh]

>> YYYYMMDD

Bear in mind that VB will have a Devil of time trying to turn this
eight-digit number back into a Date, if you ever ask it to...

Microsoft.VisualBasic.DateAndTime.DateSerial()

Although, that's not really the ".NET Way".
--
Peace & happy computing,

Mike Labosh, MCSD
Owner, vbSensei.Com
"Escriba coda ergo sum." -- vbSensei