1

I am using c#. I have a problem i am unable to remove the time format from datetime variable . Here is my code.

 string Date = ds.Tables[0].Rows[0]["serviceDate"].ToString();
string ServiceDate = string.Format("{0:MM/dd/yyyy}", Date);

How to remove the time from this format?

X3Vikas
  • 81
  • 3
  • 8
  • I assume the column "serviceDate" is already a DateTime-object, why do you want to convert it to string? Just use it as DateTime as it is. – Esko Jul 06 '18 at 06:52
  • 3
    Wait, are you talking about the _content_ of the DateTime variable, or the _display_ of it? Do you want to throw away the time component, or just not show it on the screen? – Ryan Lundy Jul 06 '18 at 06:54
  • You can't remove the "Time Format" from a `DateTime`. A `DateTime` doesn't have a format. You can only remove the "Time" from a `DateTime` with a call to the `.Date` property. – Enigmativity Jul 06 '18 at 06:58
  • You really need to provide a [mcve] to get a good answer. – Enigmativity Jul 06 '18 at 07:02

3 Answers3

1

Call the Date property on your DateTime.

It gives you a DateTime with the same date, but with the time set to midnight.

Ryan Lundy
  • 187,365
  • 35
  • 174
  • 206
0

By converting the Date into DateTime it will work fine.

 DateTime date = Convert.ToDateTime(ds.Tables[0].Rows[0]["serviceDate"]);
 string serviceDate = string.Format("{0:MM/dd/yyyy}", date);

Or if your serviceDate Field is already a Datetime then you can try this.

string ServiceDate = string.Format("{0:MM/dd/yyyy}", ds.Tables[0].Rows[0]["serviceDate"]);
shami sheikh
  • 515
  • 1
  • 9
  • 25
-1

DateTime.Parse(ds.Tables[0].Rows[0]["serviceDate"].ToString()).ToShortDateString()

Rosita Esmaili
  • 1
  • 2