Extract values from DataReader

[Michel Vanderbeke]

When a DataReader returns a DateTime field, I want to show the year-part or
month-part of the date.
How can I do this?

txtLine = rdTest("PE_Datum").ToString
gives the complete field. I just want to show only the year, or the month.
When showing the month, I want to be able to show it in full (march) or in
number (03).

Any help is appreciated.

Many thanks,

Michel

[Martin Honnen]

Michel Vanderbeke wrote:

When a DataReader returns a DateTime field, I want to show the year-part or
month-part of the date.
How can I do this?

txtLine = rdTest("PE_Datum").ToString
gives the complete field. I just want to show only the year, or the month.
When showing the month, I want to be able to show it in full (march) or in
number (03).

<http://msdn2.microsoft.com/en-us/library/System.Globalization.DateTimeFormatInfo.aspx>

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[Mihai]

Dim dAsOfDate As DateTime

dAsOfDate = DateTime.Today

dAsOfDate.Year it gives you the year

dAsOfDate.Month it gives you the month as integer

String.Format("{0:MMM}", dAsOfDate) it gives you the Month = JUN

String.Format("{0:MMMM}", dAsOfDate) it gives you the Month = JUNE

Regards,

Mihai

"Michel Vanderbeke" <mi***************@skynet.bewrote in message
news:uU**************@TK2MSFTNGP04.phx.gbl...

When a DataReader returns a DateTime field, I want to show the year-part

or

month-part of the date.
How can I do this?

txtLine = rdTest("PE_Datum").ToString
gives the complete field. I just want to show only the year, or the

month.

When showing the month, I want to be able to show it in full (march) or in
number (03).

Any help is appreciated.

Many thanks,

Michel