Last post Jun 06, 2017 10:44 AM by mgebhard
Jun 06, 2017 10:38 AM|cplusplus1|LINK
I have the following c# script, i want the date format to be yyyyMMdd
the below script writing to excel worksheet cell.
ws.Cells[i + 2, 7].Value = list2[i].INVOICE_DATE.ToShortDateString();
Thanks a lot for the helpful info
Jun 06, 2017 10:44 AM|mgebhard|LINK
The format is exactly as you wrote above...
ws.Cells[i + 2, 7].Value = list2[i].INVOICE_DATE.ToString("yyyyMMdd");
That is if list2[i] is a DateTime type which is unknown given the snippet of code above.