Regarding DateTime

Question

Good morning friends,  how to avoid time portion from the datetime variable ? i dont want to use it by converting tostring() methord. any other way to avoid the time portion. i am getting the value like  1/12/2015 12:00:00 i need the date only. please help me to find out the solution   Thanks

Manish Kumar Choudhary · Accepted Answer

for Rdlc report use
=CDate(Fields!IssuingDate.Value).ToString("dd-MMM-yyyy")
with Date columns

shiju kv · Answer

thank you so much sir . its get cleared

Manish Kumar Choudhary · Answer

Change date format in report viewer = IIF ( Year ( Fields ! DATE_SENT . Value )= 1900 , "-" , Format (CDate( Fields ! DATE_SENT . Value) , "yyyy-MM-dd" ))

Manish Kumar Choudhary · Answer

Go through following link and modify your data in report viewer     http://stackoverflow.com/questions/9140630/how-to-remove-the-time-and-display-the-date-only-in-rdlc

shiju kv · Answer

sir where i have to write this line of code

shiju kv · Answer

sir its just report viewer

Manish Kumar Choudhary · Answer

which reporting tools you are using for your report ?
show me your report query ?

shiju kv · Answer

date.
when i open the show table data the time is not added with it .
but when i load to a report it shows

Manish Kumar Choudhary · Answer

what data type you use in  totaltb  for DateTime in sql server ?

shiju kv · Answer

DateTime date1 = Convert.ToDateTime(datetimepicker1.Text);                     date1 = date1.Date;                     total = decimal.Parse(total1txt.Text);                     int i = sdb.execute("insert into totaltb values('" + receiptnum + "','" + date1 + "','" + total + "')");