How to get Last Date

Hi ramco

you can iterate through the rows of your data structure and check the value in the fifth column. Once you encounter the value "8", you can retrieve the date value from the previous row.

Here's a sample code snippet demonstrating this logic:

DateTime? previousDate = null;

for (int i = 0; i < dataTable.Rows.Count; i++)
{
    DataRow row = dataTable.Rows[i];
    int fifthColumnValue = Convert.ToInt32(row[4]); // Assuming the fifth column index is 4 (zero-based index)

    if (fifthColumnValue == 8)
    {
        if (i > 0 && previousDate != null)
        {
            DateTime dateBeforeEight = (DateTime)previousDate;
            // Use the 'dateBeforeEight' value as needed
            break; // Exit the loop after finding the date before the value "8"
        }
    }
    else
    {
        // Retrieve the date value from the current row and update 'previousDate'
        previousDate = Convert.ToDateTime(row[0]); // Assuming the date value is in the first column (zero-based index)
    }
}