Remove the time part in record access

[juliogyn]

I am selecting the date field in the table contained in the access, but registration is with the time part. 21/08/2013 00:00:00 How can i do, for remove 00:00:00 parts ?! I tried:

textnox_1.text = String.Format("{0:MM/dd/yyyy}",field);

But not resolved.

[Lost User]

What does "not resolved" mean? Did it display a time-part in the textbox? Or are you trying to remove it from the database itself?

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

[juliogyn]

the time-part does not remove ! :(

[Mycroft Holmes]

As Eddy has said, your explanation is not very clear! Your use of stringformat indicates you are trying to display a datetime - what you have will work for the display. If you are then storing the value in a datetime field in database it MUST always have a time component and will be 00:00:00 for that format. You can use the Date format in SQL Server but that is a relatively new data type. NEVER store dates as strings.

Never underestimate the power of human stupidity RAH

[wthwinner]

youtextnox_1.text = DateTime.Parse(field).ToString("MM/dd/yyyy");

[wthwinner]

textnox_1.text = DateTime.Pares(field).ToString("MM/dd/yyyy");

[CodeBlack]

You can use as mentioned below :

textnox_1.text = field.ToString("MM/dd/yyyy");

Note : DataType of the field should be datetime. otherwise you will have to convert it to DateTime.

Regards, CodeBlack

[juliogyn]

Tanks man, resolved.