Answered MS Project 2010 - How to add Custom date formats

  • יום ראשון 29 אפריל 2012 06:48
     
     

    Is there a way to add Custom Date formats in MS Project?

    e.g. I need to display date as mmm-yyyy (Feb-2012). The available list does not include such a format.

    Regards,

    Manoj

כל התגובות

  • יום ראשון 29 אפריל 2012 17:12
     
     תשובה

    It is not possible to apply a customized date display format to Project in application level.

    We can display date values of any field in another custom field using a formula. For example, the following formula in Text1 field displays Start dates in mmm-yyyy format: Format( [Start], "mmm-yyyy")

    Regards.

  • יום ראשון 29 אפריל 2012 21:20
    מנחה דיון
     
     תשובה
    Technically date formats can be changed, but only by changing the date format under Windows' control panel and regional settings. Since you can't anticipate what other PC's settings will be, Project User's suggestion of using a custom Text field is the better option.

    Rod Gill

    The one and only Project VBA Book

    Rod Gill Project Management