Can I format a string while using strWriter.Write?

Question

Hi

I'm extracting information from a Excel file to be written to a CSV file using strWriter.

strWriter.Write(oSheet.Cells[32 + i, 9].Value() + ","); /// "Ship Date"

but the value returned is "29/07/2016 00:00:00" which is no use as I only need the date.

I.e. "29/07/2016"

Does anyone know if it is possible to remove the time from the string.

Regards

David

ali tuncer · Answer

if value is string you can split by ' ' and take the first part : oSheet.Cells[32 + i 9].Value().Split(' ')[0] if it is datetime object you can useToShortDateString method check here for details : http://stackoverflow.com/questions/4357707/remove-time-from-a-date-time-string