In the Data Formating Expression for the column with your date put in the following:
{0:d}
For more information look at DataFormatString property in the VS .NET help.
>Date is pulled from a VFP table and is magically converted to DateTime format when pulled into a .Net dataset. Im trying to display the date in MM/DD/YY format in a grid column using the columns collection editor under the datagrid properties by entering into the format field various function calls such as mdate.tshortdatestring() and pic statements such as mm/dd/yy, m/d/y, etc... Everything I enter is displayed in the grid column literally. Ive tried enclosing in quotes, brackets and such. This must be something easy but couldnt find any samples.
>
>Best regards,
>
>Todd
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi