Variable date inside text column

[ET902]

I would like to have a date, such as the start date, included with text that
I enter in a Text column.

In particular this is a bar formatting, project presentation, question.
There are instances due to limited real estate in presenting the schecdule
that I would like to have the start date included with text tagged to a bar.
Say I have a milestone and I want the text to the right of the bar, I also
want the date before or after the text in the same position. I want the date
to update automatically. Any suggestions?

 

[Trevor Rabey]

Easy..

Use a spare date field called NOW to store the function NOW().
create a Milestone Task (Dur = 0) called NOW.
Copy the NOW field of that Task and Paste Special, Link into the Start of
the Task.
format the bar with text etc.

 

[ET902]

I may be doing it wrong, but this does not change the date automatically. I
want the text tagged to the bar to be "Milestone Name_Date YYY" and have the
date change as the start date changes

 

[JulieS]

Hi ET902,

You'll have to add a spare Text field (Text1 for example) and use a
formula to combine the Task Name and Start date.

For example:
[Name] & " " & [Start]

Then choose Format > Bar Styles in the menu. Select the Milestone bar.
At the bottom of the dialog box, click the Text tab and select Text1 (or
your custom text field) from the list next to left, right, top, bottom,
or inside.

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

Julie

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

 

[ET902]

Outstanding...almost! It is putting the extended date in the customized text
field, eventhough the Project date format is "9/1/06" it is showing as
"9/1/06 8:00 AM". Anyway to have a short date format in the customized field?

Hi ET902,

You'll have to add a spare Text field (Text1 for example) and use a
formula to combine the Task Name and Start date.

For example:
[Name] & " " & [Start]

Then choose Format > Bar Styles in the menu. Select the Milestone bar.
At the bottom of the dialog box, click the Text tab and select Text1 (or
your custom text field) from the list next to left, right, top, bottom,
or inside.

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

Julie

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

I may be doing it wrong, but this does not change the date
automatically. I
want the text tagged to the bar to be "Milestone Name_Date YYY" and
have the
date change as the start date changes

 

[JulieS]

Hi ET902,

Try:
[Name] & " " & Format([Start],"MM/DD/YY")

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

Julie

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

Outstanding...almost! It is putting the extended date in the
customized text
field, eventhough the Project date format is "9/1/06" it is showing as
"9/1/06 8:00 AM". Anyway to have a short date format in the customized
field?

Hi ET902,

You'll have to add a spare Text field (Text1 for example) and use a
formula to combine the Task Name and Start date.

For example:
[Name] & " " & [Start]

Then choose Format > Bar Styles in the menu. Select the Milestone
bar.
At the bottom of the dialog box, click the Text tab and select Text1
(or
your custom text field) from the list next to left, right, top,
bottom,
or inside.

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

Julie

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

I may be doing it wrong, but this does not change the date
automatically. I
want the text tagged to the bar to be "Milestone Name_Date YYY"
and
have the
date change as the start date changes

:

Easy..

Use a spare date field called NOW to store the function NOW().
create a Milestone Task (Dur = 0) called NOW.
Copy the NOW field of that Task and Paste Special, Link into the
Start of
the Task.
format the bar with text etc.



I would like to have a date, such as the start date, included
with
text
that
I enter in a Text column.

In particular this is a bar formatting, project presentation,
question.
There are instances due to limited real estate in presenting the
schecdule
that I would like to have the start date included with text
tagged
to a
bar.
Say I have a milestone and I want the text to the right of the
bar,
I also
want the date before or after the text in the same position. I
want
the
date
to update automatically. Any suggestions?

 

[ET902]

Thanks Julie. That works great.

Hi ET902,

Try:
[Name] & " " & Format([Start],"MM/DD/YY")

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

Julie

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

Outstanding...almost! It is putting the extended date in the
customized text
field, eventhough the Project date format is "9/1/06" it is showing as
"9/1/06 8:00 AM". Anyway to have a short date format in the customized
field?

Hi ET902,

You'll have to add a spare Text field (Text1 for example) and use a
formula to combine the Task Name and Start date.

For example:
[Name] & " " & [Start]

Then choose Format > Bar Styles in the menu. Select the Milestone
bar.
At the bottom of the dialog box, click the Text tab and select Text1
(or
your custom text field) from the list next to left, right, top,
bottom,
or inside.

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

Julie

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


I may be doing it wrong, but this does not change the date
automatically. I
want the text tagged to the bar to be "Milestone Name_Date YYY"
and
have the
date change as the start date changes

:

Easy..

Use a spare date field called NOW to store the function NOW().
create a Milestone Task (Dur = 0) called NOW.
Copy the NOW field of that Task and Paste Special, Link into the
Start of
the Task.
format the bar with text etc.



I would like to have a date, such as the start date, included
with
text
that
I enter in a Text column.

In particular this is a bar formatting, project presentation,
question.
There are instances due to limited real estate in presenting the
schecdule
that I would like to have the start date included with text
tagged
to a
bar.
Say I have a milestone and I want the text to the right of the
bar,
I also
want the date before or after the text in the same position. I
want
the
date
to update automatically. Any suggestions?

 

[JulieS]

You're most welcome ET902 and thanks for the feedback.

Julie

Thanks Julie. That works great.

Hi ET902,

Try:
[Name] & " " & Format([Start],"MM/DD/YY")

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

Julie

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

Outstanding...almost! It is putting the extended date in the
customized text
field, eventhough the Project date format is "9/1/06" it is showing
as
"9/1/06 8:00 AM". Anyway to have a short date format in the
customized
field?

:

Hi ET902,

You'll have to add a spare Text field (Text1 for example) and use
a
formula to combine the Task Name and Start date.

For example:
[Name] & " " & [Start]

Then choose Format > Bar Styles in the menu. Select the Milestone
bar.
At the bottom of the dialog box, click the Text tab and select
Text1
(or
your custom text field) from the list next to left, right, top,
bottom,
or inside.

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

Julie

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


I may be doing it wrong, but this does not change the date
automatically. I
want the text tagged to the bar to be "Milestone Name_Date YYY"
and
have the
date change as the start date changes

:

Easy..

Use a spare date field called NOW to store the function NOW().
create a Milestone Task (Dur = 0) called NOW.
Copy the NOW field of that Task and Paste Special, Link into
the
Start of
the Task.
format the bar with text etc.



I would like to have a date, such as the start date, included
with
text
that
I enter in a Text column.

In particular this is a bar formatting, project presentation,
question.
There are instances due to limited real estate in presenting
the
schecdule
that I would like to have the start date included with text
tagged
to a
bar.
Say I have a milestone and I want the text to the right of
the
bar,
I also
want the date before or after the text in the same position.
I
want
the
date
to update automatically. Any suggestions?