This was a specific request from one of my clients on a project,  for some filtered activities he wanted to know the ordinal duration in months from a specific date in the project. You can check ordinal durations in timescale but getting them in a column in your layout is not that straight forward.

We will work on getting Ordinal Months for activities in this example. Create 3 User Defined Fields (UDF) ;

1) Ordinal Start Date – This UDF will have the date from which you want to calculate Ordinal durations

Data Type – Start Date

2) Ordinal Days – This UDF will contain calculated durations in days from the ordinal start date

Data Type – Integer

3) Ordinal Months – This UDF will have calculated ordinal months

Data Type – Integer

We add column for Ordinal Start Date in the layout and enter the date from which we want to calculate Ordinal Months for the activities.

We will have to create 2 global changes to calculated the number of days and then convert it into months for the activities

1) Global Change – Ordinal Dates

Ordinal Days = Start – Ordinal Start Date

This global change calculates the number of calendar days between the date you have for ordinal start and the current start date.

2) Global Change – Ordinal Months

Ordinal Months = Ordinal Day / 30

This global change converts the number of days into months

After creating the Global Change, you will have to run them in the following order; Ordinal Dates > Ordinal Months. You will also have to re-run these global changes everytime you reschedule your project with some changes.

After running the global changes you will get your ordinal values in the layout and you can print them as a report. The only problem that comes in the layout is that the summary bands of ordinal days and ordinal months show cumulative values and you can disable this by unchecking “Show Group Totals” in Group and Sort.