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
  • Thank you very much Ismet, this is going a significant step towards the customisation I was looking for.

    The side effect hereof, unfortunately, is that the structured filtering and/or grouping capability (by year, month, etc) is lost as it is converted to a Text field.

    Would there by any chance something similar be possible by using a Date custom field ? I'm unfortunately not proficient enough with those advanced features of Project like formulas and couldn't find a way to actually do this, as the Format function seem to apply only for Text fields, correct ? Any other hint ?

    Thanks for your advice in advance !

    Thursday, October 26, 2017 8:17 PM
  • AlterMind64,

    I'm not sure how often Ismet checks this forum but at the risk of stealing his thunder, let me address your issue.

    No, it is not possible to custom format a date field other than through Project or Windows Control Panel options.

    With regard to filtering or grouping, the basic date time information is always available regardless of how the user might display it in a custom formatted field. For example, let's say you want to custom format the Start field so you do that in a Text field as Ismet suggested. Then you want to filter or group on that date. Use the Start field itself as the filter/grouping criteria. Remember, custom formatting is for presentation only, it does not impact how Project stores date time information internally.

    Hope this helps.

    John

    • Proposed as answer by Ismet Kocaman Friday, October 27, 2017 6:22 AM
    Thursday, October 26, 2017 10:09 PM