Return year only from datetime field

Try this:

Dim dr As DataRow
        For Each dr In dscomm.Rows
            Dim reportData as datetime = Ctype(dr("ReportYear"),DateTime)
            reportYear += reportData.Year
        Next

Select allOpen in new window

use similar code  :

DateTime.parse (dr("ReportYear").ToString()).Year;

You just can get it, if you use the YEAR scalar function of SQL;
SQL statement...
"Select year(date_field), date_field, another_field from table"

FerG
Saludos.
--
Ing. Fernando D. Giletta
San Fco. Cba. Argentina.

Use SQL YEAR function. Change your sql select query to something like this:
Select YEAR(theDateTimeFieldName) As ReportYear From YourTable

Both codes work, but it seems they are adding the years together instead of giving me each year. The outcome of both scenarios is 6009
Years are 2002,2003, 2004?

Arghhhhhh, fingers are not working fast enough.

It's because this line:

 reportYear += reportData.Year

The "+" sign means that you are adding to.

That's what I thought but

 For Each dr In dscomm.Rows
            Dim reportData As DateTime = CType(dr("ReportYear"), DateTime)
            reportYear = reportData.Year
        Next

only returns the last record.

Yes, because it overwrites reportYear every time it enters the loop, giving you the last record value as a result.
Do you need all the year in separate strings?

Juan, yes I need to show all of them on the page.

then you could use something like this, it will give you a list containing all the years:

Dim reportYear As List(Of String)
For Each dr In dscomm.Rows
    Dim reportData As DateTime = CType(dr("ReportYear"), DateTime)
    reportYear.Add(reportData.Year)
Next

Select allOpen in new window

Juan, I apologize, I'm still not getting it. I added the import statement for System.Collections.Generic and still get an error:

Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:


Line 85:         For Each dr In dscomm.Rows
Line 86:             Dim reportData As DateTime = CType(dr("ReportYear"), DateTime)
Line 87:             reportYear.Add(reportData.Year) 'highlighted as error
Line 88:         Next

 
the table doesn't have any null values. What am I missing?

Oops, I'm sorry, it should be like this (missed the New keyword):

Dim reportYear As New List(Of String)
For Each dr In dscomm.Rows
    Dim reportData As DateTime = CType(dr("ReportYear"), DateTime)
    reportYear.Add(reportData.Year)
Next

Select allOpen in new window

I tried that as well and the output on the page is:

System.Collections.Generic.List`1[System.String]

Public variable up top Public reportYear As New List(Of String)

Then below

Dim dr As DataRow
        For Each dr In dscomm.Rows
            Dim reportData As DateTime = CType(dr("ReportYear"), DateTime)
            reportYear.Add(reportData.Year)
        Next

Okay, tested the value of outputToDisplay and all the years show up separated by a comma. I'll tweak it for my page display now. Thank you very much for walking me through this and your quick responses!

No worries, I'm glad it works!