I want only date not to see time

Question

C# visual studio 2015 database MS Access 2007. When I use iTextSharp report for any date then I found: 26-Feb-17 12:00:00 AM I do not want any time in the report. Please code or example.

Amit Gupta · Answer

Look at the FORMAT function: http://www.techonthenet.com/access/functions/date/format.php SELECT FORMAT(DOB dd/mm/yyyy ) AS DOB FROM Tbl_Employee Or in code behind file you can use var dt = 26-Feb-17 12:00:00 AM ; var result = DateTime.Parse (dt).ToString ( dd-MMM-yy );

Yogendra Bhardwaj · Answer

Please parse you date value in a required format.

I want only date, not to see time