returning date as time in csv file

You can use DateTime.TryParse to validate a string is date. If it is date, then Get time part from it using specific format. Look at sample code. Use it as a method and call for each cell value in your code.

Otherwise there is better option.. store the timevalue alone datatable by updating the database query to to fill the datatable. No need to check each and every value.....

string sDateTime = Convert.ToString(cell); //Check for each cell...
DateTime dt;
DateTime.TryParse(sDateTime ,out dt);

if(dt != null)
{
DateTime dt = DateTime.Parse(sDateTime); 
dt.ToString("HH:mm"); // 07:00 // 24 hour clock // hour is always 2 digits 
dt.ToString("hh:mm tt"); // 07:00 AM // 12 hour clock // hour is always 2 digits 
dt.ToString("H:mm"); // 7:00 // 24 hour clock dt.ToString("h:mm tt"); // 7:00 AM // 12 hour clock 
}

Select allOpen in new window

Hello, I did these examples for you based in what you are asking and some observations:

Case 1, Assuming that your cell contains a System.String instead of a System.DataTime type, then you will need to parse its value to a DateTime type.

System.Globalization.CultureInfo ciUs = new System.Globalization.CultureInfo("en-US");
foreach (DataRow row in dTable.Rows)
{
    int cellCount = 0;
    foreach (Object cell in row.ItemArray)
    {
        if (cellCount == 2)// I'm assuming that your cell at index 2 contains the date, change the index to the correct one.
        {
            // Assuming that your cell contains a System.String instead of a System.DataTime type, then you will need to parse its value to a DateTime type.
            DateTime myDate = DateTime.MinValue;
            if (DateTime.TryParse(cell.ToString(), ciUs, System.Globalization.DateTimeStyles.None, out myDate))
            {
                if (myDate.TimeOfDay.TotalSeconds == 0)
                    strbldr.Append(myDate.ToString("d", ciUs) + ',');//When time is 0 return the Date part.
                else
                    strbldr.Append(myDate.ToString("t", ciUs) + ',');//otherwise return the Time part.
            }
            else
            {
                strbldr.Append(',');
            }
        }
        else
        {
            //separating gridview columns with comma
            strbldr.Append(Convert.ToString(cell) + ',');
        }

        cellCount++;
    }
    //appending new line for gridview rows
    strbldr.Append("\n");
}

Select allOpen in new window

Case 2, Assuming that your cell contain a System.DateTime value, instead of a string, this is a better way to cast its value.

System.Globalization.CultureInfo ciUs = new System.Globalization.CultureInfo("en-US");
foreach (DataRow row in dTable.Rows)
{
    int cellCount = 0;
    foreach (Object cell in row.ItemArray)
    {
        if (cellCount == 2)// I'm assuming that your cell at index 2 contains the date, change the index to the correct one.
        {
            // Assuming that your cell contain a System.DateTime value, instead of a string, this is a better way to cast its value.
            DateTime myDate = Convert.ToDateTime(cell);
            if (myDate.TimeOfDay.TotalSeconds == 0)
                strbldr.Append(myDate.ToString("d", ciUs) + ',');//When time is 0 return the Date part.
            else
                strbldr.Append(myDate.ToString("t", ciUs) + ',');//otherwise return the Time part.
        }
        else
        {
            //separating gridview columns with comma
            strbldr.Append(Convert.ToString(cell) + ',');
        }

        cellCount++;
    }
    //appending new line for gridview rows
    strbldr.Append("\n");
}

Select allOpen in new window

For both case you will need to change the index (in my example 2), of the cell that contain the DateTime value.

Also, your csv data rows are leaving an extra comma (,) at the end, I think that you need to remove it.

This other example will control the commas and the new line in a different way, is based in the case #1:

System.Globalization.CultureInfo ciUs = new System.Globalization.CultureInfo("en-US");
foreach (DataRow row in dTable.Rows)
{
    int cellCount = 0;
    foreach (Object cell in row.ItemArray)
    {
        if (cellCount > 0)
            strbldr.Append(',');

        if (cellCount == 2)// I'm assuming that your cell at index 2 contains the date, change the index to the correct one.
        {
            // Assuming that your cell contains a System.String instead of a System.DataTime type, then you will need to parse its value to a DateTime type.
            DateTime myDate = DateTime.MinValue;
            if (DateTime.TryParse(cell.ToString(), ciUs, System.Globalization.DateTimeStyles.None, out myDate))
            {
                if (myDate.TimeOfDay.TotalSeconds == 0)
                    strbldr.Append(myDate.ToString("d", ciUs));//When time is 0 return the Date part.
                else
                    strbldr.Append(myDate.ToString("t", ciUs));//otherwise return the Time part.
            }
        }
        else
        {
            //separating gridview columns with comma
            strbldr.Append(Convert.ToString(cell));
        }

        cellCount++;
    }
    //appending new line for gridview rows
    strbldr.AppendLine();
}

Select allOpen in new window

the fields in the database (access) are both date/times. I format them within the db to show the desired values
I am not accustomed to programming in aspx at all, I am not sure how to integrate the method into the file that I have now.

Ok, I can help you with that, but I need the structure of your RainEvents table, so I can do the corrects changes to the code for you.

Ignore the comment:

// I'm assuming that your cell at index 2 contains the date, change the index to the correct one.

In the previous post.

@yg989c,
I appreciate your help very much!
I am loading a jpg so you can see what the format for my columns are. the date-deployed and collection date are shortdate formats
and the collection_time long time format
I also apologize for the time in getting back with you. I was stuck in a meeting.
raineventsformat.JPG

Don't worry, have you tried my last post?
https://www.experts-exchange.com/questions/27404334/returning-date-as-time-in-csv-file.html?cid=1572&anchorAnswerId=36993218#a36993218

honestly I have not...I am working on it now, All I should have to do is replace the code in my aspx.cs page with the code you changed - correct?

Yes, only the cmdSend_Click method.

That worked perfect! Thank you very much

Glad to help!