Bar Text Date format

[Robert H]

I have set up a text field with the formula "[Name] & ", " & [Start]"
as recommended here in the newsgroup. The field is assigned to the
right side bar text for milestones. heverything looks great except
the date formate includes time. this is not the default setting and I
cannot find which date format effects the bar text.
how do I set the Bar Text Date format

Thanks

 

[JulieS]

Hi Robert,

Modify your formula in the text field to:

[Name] & ", " & Format([Start],"mm/dd/yy")

Adjust as necessary for date formats other than US.

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

"Robert H" wrote in message
news:[email protected]...

 

[Robert H]

Thanks Julie, that worked perfect

Hi Robert,

Modify your formula in the text field to:

[Name] & ", " & Format([Start],"mm/dd/yy")

Adjust as necessary for date formats other than US.

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

Julie
Project MVP

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

"Robert H"  wrote in message

I have set up a text field with the formula "[Name] & ", " &
[Start]"
as recommended here in the newsgroup.  The field is assigned to
the
right side bar text for milestones.  heverything looks great
except
the date formate includes time.  this is not the default setting
and I
cannot find which date format effects the bar text.
how do I set the Bar Text Date format

Thanks- Hide quoted text -

- Show quoted text -

 

[JulieS]

You're welcome Robert. Glad to have helped and thanks for the
feedback.

Julie

"Robert H" wrote in message
Thanks Julie, that worked perfect

Hi Robert,

Modify your formula in the text field to:

[Name] & ", " & Format([Start],"mm/dd/yy")

Adjust as necessary for date formats other than US.

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

Julie
Project MVP

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

in message

I have set up a text field with the formula "[Name] & ", " &
[Start]"
as recommended here in the newsgroup. The field is assigned to
the
right side bar text for milestones. heverything looks great
except
the date formate includes time. this is not the default setting
and I
cannot find which date format effects the bar text.
how do I set the Bar Text Date format

Thanks- Hide quoted text -

- Show quoted text -