none
MS Project 2010 - How to add Custom date formats

    Question

  • 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

    Sunday, April 29, 2012 6:48 AM

Answers

  • 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.

    Sunday, April 29, 2012 5:12 PM
  • 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

    Sunday, April 29, 2012 9:20 PM
    Moderator

All replies

  • 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.

    Sunday, April 29, 2012 5:12 PM
  • 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

    Sunday, April 29, 2012 9:20 PM
    Moderator