Format MM/YY for Milestone date

[John Pinback]

How can I format milestone dates as MM/YY like 08/14?

Thanks,
Karl

 

[JulieS]

Hello Karl,

Where do you want to show the format? Table? Gantt chart? What
version of Project?

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[John Pinback]

Julie,

It is a Gantt chart. Project 2003. I tried adding a column into the table
that is to the left of teh bars with Format([Start],"MM/YY") but it says the
date is invalid.

Karl

 

[JulieS]

Hello John,

Try this formula in a text field:

IIf([Milestone]=-1,Format([Start],"mm/yy"),[Start])

It will show only month and year for the start date of milestone tasks
and just the regular start date for non-milestone tasks. You can then
use the Text(n) field for the display on the Gantt.


I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

Julie,

It is a Gantt chart. Project 2003. I tried adding a column into the
table that is to the left of teh bars with Format([Start],"MM/YY")
but it says the date is invalid.

Karl

Hello Karl,

Where do you want to show the format? Table? Gantt chart? What
version of Project?

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

 

[John Pinback]

I set the Bar Style for Milesstone to Text26 for teh right side of teh bar.
Then I added a column to the table that appears to teh left of teh Gantt
chart and inserted a new column for Text26. Then I pasted
IIf([Milestone]=-1,Format([Start],"mm/yy"),[Start]) into the formula bar.
The text appears in the first cell but nothing else happens.

Karl

Hello John,

Try this formula in a text field:

IIf([Milestone]=-1,Format([Start],"mm/yy"),[Start])

It will show only month and year for the start date of milestone tasks and
just the regular start date for non-milestone tasks. You can then use the
Text(n) field for the display on the Gantt.


I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

Julie,

It is a Gantt chart. Project 2003. I tried adding a column into the table
that is to the left of teh bars with Format([Start],"MM/YY") but it says
the date is invalid.

Karl

Hello Karl,

Where do you want to show the format? Table? Gantt chart? What
version of Project?

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project



How can I format milestone dates as MM/YY like 08/14?

Thanks,
Karl

 

[JulieS]

Hi Karl

(Sorry for calling you John earlier). You need the place the formula
I posted into the formula portion of the Customize Fields dialog box.

For step by step:
1. Right click on the column heading for Text26 to show the shortcut
menu.

2. Choose Customize Fields... to open the Customize Fields dialog box.
Text26 should be selected in the list of field to customize.

3. In the Custom attributes section, click the Formula.... button to
open the Formula for Text26 dialog box.
4. Paste the formula I gave you earlier as written into the dialog
box.

5. Click the OK button to close the Formula for Text26 dialog box and
return to the Customize Fields dialog box.

6. Click the OK button to close the Customize Fields dialog box.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

I set the Bar Style for Milesstone to Text26 for teh right side of
teh bar. Then I added a column to the table that appears to teh left
of teh Gantt chart and inserted a new column for Text26. Then I
pasted IIf([Milestone]=-1,Format([Start],"mm/yy"),[Start]) into the
formula bar. The text appears in the first cell but nothing else
happens.

Karl

Hello John,

Try this formula in a text field:

IIf([Milestone]=-1,Format([Start],"mm/yy"),[Start])

It will show only month and year for the start date of milestone
tasks and just the regular start date for non-milestone tasks. You
can then use the Text(n) field for the display on the Gantt.


I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

Julie,

It is a Gantt chart. Project 2003. I tried adding a column into
the table that is to the left of teh bars with
Format([Start],"MM/YY") but it says the date is invalid.

Karl

"JulieS" <passport6847 at maine dot rr dot com> wrote in message
Hello Karl,

Where do you want to show the format? Table? Gantt chart? What
version of Project?

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project



How can I format milestone dates as MM/YY like 08/14?

Thanks,
Karl

 

[John Pinback]

Julie,

Perfect! Thanks for the step by step instructions.

Karl

Hi Karl

(Sorry for calling you John earlier). You need the place the formula I
posted into the formula portion of the Customize Fields dialog box.

For step by step:
1. Right click on the column heading for Text26 to show the shortcut menu.

2. Choose Customize Fields... to open the Customize Fields dialog box.
Text26 should be selected in the list of field to customize.

3. In the Custom attributes section, click the Formula.... button to open
the Formula for Text26 dialog box.
4. Paste the formula I gave you earlier as written into the dialog box.

5. Click the OK button to close the Formula for Text26 dialog box and
return to the Customize Fields dialog box.

6. Click the OK button to close the Customize Fields dialog box.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

I set the Bar Style for Milesstone to Text26 for teh right side of teh
bar. Then I added a column to the table that appears to teh left of teh
Gantt chart and inserted a new column for Text26. Then I pasted
IIf([Milestone]=-1,Format([Start],"mm/yy"),[Start]) into the formula bar.
The text appears in the first cell but nothing else happens.

Karl

Hello John,

Try this formula in a text field:

IIf([Milestone]=-1,Format([Start],"mm/yy"),[Start])

It will show only month and year for the start date of milestone tasks
and just the regular start date for non-milestone tasks. You can then
use the Text(n) field for the display on the Gantt.


I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project



Julie,

It is a Gantt chart. Project 2003. I tried adding a column into the
table that is to the left of teh bars with Format([Start],"MM/YY") but
it says the date is invalid.

Karl

"JulieS" <passport6847 at maine dot rr dot com> wrote in message
Hello Karl,

Where do you want to show the format? Table? Gantt chart? What
version of Project?

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project



How can I format milestone dates as MM/YY like 08/14?

Thanks,
Karl

 

[JulieS]

You're most welcome Karl and thanks for the feedback

Julie
Project MVP

Julie,

Perfect! Thanks for the step by step instructions.

Karl

Hi Karl

(Sorry for calling you John earlier). You need the place the
formula I posted into the formula portion of the Customize Fields
dialog box.

For step by step:
1. Right click on the column heading for Text26 to show the
shortcut menu.

2. Choose Customize Fields... to open the Customize Fields dialog
box.
Text26 should be selected in the list of field to customize.

3. In the Custom attributes section, click the Formula.... button
to open the Formula for Text26 dialog box.
4. Paste the formula I gave you earlier as written into the dialog
box.

5. Click the OK button to close the Formula for Text26 dialog box
and return to the Customize Fields dialog box.

6. Click the OK button to close the Customize Fields dialog box.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

I set the Bar Style for Milesstone to Text26 for teh right side of
teh bar. Then I added a column to the table that appears to teh
left of teh Gantt chart and inserted a new column for Text26. Then
I pasted IIf([Milestone]=-1,Format([Start],"mm/yy"),[Start]) into
the formula bar. The text appears in the first cell but nothing
else happens.

Karl

"JulieS" <passport6847 at maine dot rr dot com> wrote in message
Hello John,

Try this formula in a text field:

IIf([Milestone]=-1,Format([Start],"mm/yy"),[Start])

It will show only month and year for the start date of milestone
tasks and just the regular start date for non-milestone tasks.
You can then use the Text(n) field for the display on the Gantt.


I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project



Julie,

It is a Gantt chart. Project 2003. I tried adding a column into
the table that is to the left of teh bars with
Format([Start],"MM/YY") but it says the date is invalid.

Karl

"JulieS" <passport6847 at maine dot rr dot com> wrote in message
Hello Karl,

Where do you want to show the format? Table? Gantt chart?
What version of Project?

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project



How can I format milestone dates as MM/YY like 08/14?

Thanks,
Karl