Ordinal Dates

[BJH]

I'm trying to show Ordinal Start/Finish dates, using a custom field
(formula). Is there an easier way to show this information?

 

[John]

I'm trying to show Ordinal Start/Finish dates, using a custom field
(formula). Is there an easier way to show this information?

BJH,
If I recall correctly, ordinal implies order but that can take different
forms. If you can give us an example of what you are trying to display,
it would be easier to help you.

John
Project MVP

 

[BJH]

John,

By Ordinal I mean ordinal day of the project, instead of based on a calendar
date.

Task 1 has a duration of 5 days, starts on Day 0 and finishes on Day 4
Task 2 has a duration of 3 days(successor to Task 1), starts on Day 5 and
finishes on Day 7.

I believe the only way I can show this is to add a formula into 2 of the
number fields, looking to see if anyone has used another way to accomplish.

Thanks!

 

[John]

John,

By Ordinal I mean ordinal day of the project, instead of based on a calendar
date.

Task 1 has a duration of 5 days, starts on Day 0 and finishes on Day 4
Task 2 has a duration of 3 days(successor to Task 1), starts on Day 5 and
finishes on Day 7.

I believe the only way I can show this is to add a formula into 2 of the
number fields, looking to see if anyone has used another way to accomplish.

Thanks!

BJH,
Well I'm glad you explained that because I had something completely
different in mind.

You do not need a formula or even a spare field. Go to Format/Timescale
and set the Bottom Tier label to be: 1, 2, 3, 4, ...(from Start). As
long as the Units for the bottom tier are in days, you will have exactly
what you want.

Hope this helps.
John
Project MVP

 

[BJH]

John,

I actually already had the timescale on an ordinal scale, I was looking to
see if there was a simple way to show that data in the Table section/view.

 

[John]

John,

I actually already had the timescale on an ordinal scale, I was looking to
see if there was a simple way to show that data in the Table section/view.

BJH,
Sorry, I misunderstood. Unfortunately the only way to do what you want
is through either VBA or with formulas in customized spare fields.

John
Project MVP

 

[Mike Glen]

Hi BJH,

I assume you've tried Tools/Options/View/Date Format?

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

 

[BJH]

Mike,

No I actually didn't try this, but looking at the drop down, they are all
time related, not ordinal.

I think I'll go forward with the VBA/Formulas as suggested.

Thanks for the help.