Loading

Can I format a string while using strWriter.Write?

David Smith

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.