none
Format a date field in Microsoft Visual Studio RRS feed

  • Question

  • Hi I am using Microsoft Visual Studio 2005 and in Report Builder I want to format my date fields to show the english dates.  The help for SQL AServer 2005 books online says To format date values
    1. In design mode, select the cells containing the date values that you want to format.

    2. On the Format menu, click Number. (I  Have a format menu but no number)

      The Format dialog box opens with the Number tab selected. (So where is it)

    3. In the Defined formats list, select a format.

      Note:
      You can use a custom format by selecting the Custom format radio button and then specifying a valid Microsoft .NET Framework format string.

    This has been driving me mad all morning can anyone help please
    Wednesday, August 12, 2009 12:52 PM

Answers

  • There should be a Format property when you click the cell.
    Try putting:

    =Format("dd/MM/yyyy") 

    and see if it works.

    Good luck,
    Long
    Friday, August 14, 2009 9:31 PM