Am trying to extract a date format correctly base on excel format, says in excel list all start from dd/MM/yyyy, but extracted out data to email somehow would show MM/dd/yyyy 00:00:00
from excel
to output email
how to let the robot to read the format correctly and remove the time 00:00:00 at the back.
"Dear Sir/Madam,<p>This is an alert to request a quotation on the following items: <p>Description" +row("Description").ToString+"<p>Expiry Date: "+DateTime.ParseExact(row("Expiry Date").ToString,"d/M/yyyy hh:mm:ss",System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")+"<br>Serial Number: "+row("Serial No.").ToString+"<p><strong>This Is an automated email.</strong><p>Regards,<br>Email Automation Robot"
Or
"Dear Sir/Madam,<p>This is an alert to request a quotation on the following items: <p>Description" +row("Description").ToString+"<p>Expiry Date: "+CDate(row("Expiry Date").ToString).ToString("dd/MM/yyyy")+"<br>Serial Number: "+row("Serial No.").ToString+"<p><strong>This Is an automated email.</strong><p>Regards,<br>Email Automation Robot"