Deltek Open Plan Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Format Parameters and Examples

This topic provides a full list of parameters you can use in specifying the appearance of the dates in the date scale.

To define a format, click the ellipsis button next to the Format field, and select a format from the Date Formats dialog box, or enter the format manually using one or more of the following parameters:

Parameter Definition Example
%T Minute 15
%H Hour 08
%Z AM or PM AM or PM
%OZ AM or PM (lower case) am or pm
%D Day of the month 31
%V Day Tuesday
%OV Day (lower case) tuesday
%UV Day (upper case) TUESDAY
%W Day abbreviation Tues
%OW Day abbreviation (lower case) tues
%UW Day abbreviation (upper case) TUES
%F First letter of name of day of the week T
%OF First letter of the name of day of the week (lower case) t
%UF First letter of the name of day of the week (upper case) T
%K Numeric week 22
%M Numeric month 10
%L Month October
%OL Month (lower case) october
%UL Month (upper case) OCTOBER
%A Month abbreviation Oct
%OA Month abbreviation (lower case) oct
%UA Month abbreviation (upper case) OCT
%S First letter of name of month O
%OS First letter of name of month (lower case) o
%US First letter of name of month (upper case) O
%Q Numeric quarter 4
%UW Day abbreviation (upper case) TUES
%K Numeric week 22
%M Numeric month 10
%L Month October
%OL Month (lower case) october
%UL Month (upper case) OCTOBER
%A Month abbreviation Oct
%OA Month abbreviation (lower case) oct
%UA Month abbreviation (upper case) OCT
%Q Numeric quarter 4
%C Year 2004
%Y Two-digit year 04
%R%H Relative hours 100
%R%D Relative days 3
%R%K Relative weeks 22
%R%M Relative months 4
%R%Q Relative quarters 2
%R%Y Relative years 1

Because relative dates return only a numeric value, they are usually combined with literal values to make them more informative.

You can combine parameters to define date formats. You can also include spaces and literal characters in the format, as shown in the following examples.

Parameter Example
%H:%T %Z.M. 07:15 P.M.
%W %D %A %H:%T Mon 15 Sep 19:15
%M/%D/%C 09/15/2014
Q%Q Q1
Note: To show hours and minutes using the 24-hour (military) convention, do not use the %Z or the %OZ parameter in the definition of the format.

To display relative dates in a date scale, use the following parameters:

Parameter Definition
%R%H Relative hours
%R%D Relative days
%R%K Relative weeks
%R%M Relative months
%R%Q Relative quarters
%R%Y Relative years

The values displayed for dates using a relative format are based on the Reference Date setting on the Manual tab of the Date Scale Preferences dialog box. To have Open Plan convert the currently selected date format to a relative date format, select the Relative to Reference Date option in the Date Formats dialog box.

All of these different types of format parameters can be combined with literal characters to produce the following types of labels:

Format Example
%R%H Hours 100 Hours
Day %R%D Day 3
Week %R%K Week 15
FY%R%Y FY1