>The datatype is "D". The backend is VFP (have you heard of it? <g>).<LOL! No! What is VFP? <g>
Anyway, I haven't used VFP as a backend with .NET, so I'm not sure, but couldn't you read the date in as a .NET datetime datatype? Or doesn't the VFP OleDb provider handle that?
DateTime dtDateClosed = (DateTime)drWORK_HIS["date_clos"];
~~Bonnie
>
>>Dmitry,
>>
>>But what datatype is drWORK_HIS["date_clos"]? Is it a date datatype? What is your backend data?
>>
>>~~Bonnie
>>
>>
>>
>>>>Dmitry,
>>>>
>>>>Try using the following.
>>>>
>>>>DateTime test = new DateTime(4, 2, 3);
>>>>Console.WriteLine(test.Date.ToShortDateString());
>>>>
>>>>Regards
>>>>Neil
>>>
>>>
>>>Neil and Bonnie,
>>>
>>>Unfortunately my DateTime string is of type String. Here is how I get it from a Data Reader:
>>>
>>>
>>>string strDateClosed = drWORK_HIS["date_clos"].ToString();
>>>
>>>
>>>Therefore, I can't see how I can apply the method ToShortDateString to it.
>>>
>>>Thank you both for your suggestions.