David Smith

David Smith

  • NA
  • 1
  • 555

Can I format a string while using strWriter.Write?

Jul 28 2016 7:24 AM

 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 
 

Answers (1)