Prev: Project Printing Issues
Next: Redistribution Resources problem
From: bmac on 27 Jan 2010 18:29
I have a custom field with the following formula "Finish & Text4" in a column
called Text5. I then modify bar styles to display Text5 on the Gnatt chart.
Question -- the Finish value shows as 1/15/2010 8:00:00 AM. How do I modify
my formula to only show 1/15/10 and not the time. Additonally, how do I
modify the formula to have the Text4 text display in italics?
Thanks very much in advance

bmac
From: Sai on 27 Jan 2010 22:54
On Jan 28, 4:29 am, bmac <b...(a)discussions.microsoft.com> wrote:
> I have a custom field with the following formula "Finish & Text4" in a column
> called Text5. I then modify bar styles to display Text5 on the Gnatt chart.
> Question -- the Finish value shows as 1/15/2010 8:00:00 AM. How do I modify
> my formula to only show 1/15/10 and not the time. Additonally, how do I
> modify the formula to have the Text4 text display in italics?
> Thanks very much in advance
>
> bmac

Replace the formula of Text5 with this one - Format(Finish,"ddd mm/dd/
yy ") & Text4

Please let us know if this satisfies your requiremnet.

- Sai, PMP, PMI-SP, MCT, MCTS
http://saipower.wordpress.com
From: bmac on 28 Jan 2010 11:49
Works! thanks very much

"Sai" wrote:

> On Jan 28, 4:29 am, bmac <b...(a)discussions.microsoft.com> wrote:
> > I have a custom field with the following formula "Finish & Text4" in a column
> > called Text5. I then modify bar styles to display Text5 on the Gnatt chart.
> > Question -- the Finish value shows as 1/15/2010 8:00:00 AM. How do I modify
> > my formula to only show 1/15/10 and not the time. Additonally, how do I
> > modify the formula to have the Text4 text display in italics?
> > Thanks very much in advance
> >
> > bmac
>
> Replace the formula of Text5 with this one - Format(Finish,"ddd mm/dd/
> yy ") & Text4
>
> Please let us know if this satisfies your requiremnet.
>
> - Sai, PMP, PMI-SP, MCT, MCTS
> http://saipower.wordpress.com
> .
>
From: Sai on 28 Jan 2010 22:01
On Jan 28, 9:49 pm, bmac <b...(a)discussions.microsoft.com> wrote:
> Works! thanks very much
>
>
>
> "Sai" wrote:
> > On Jan 28, 4:29 am, bmac <b...(a)discussions.microsoft.com> wrote:
> > > I have a custom field with the following formula "Finish & Text4" in a column
> > > called Text5. I then modify bar styles to display Text5 on the Gnatt chart.
> > > Question -- the Finish value shows as 1/15/2010 8:00:00 AM. How do I modify
> > > my formula to only show 1/15/10 and not the time. Additonally, how do I
> > > modify the formula to have the Text4 text display in italics?
> > > Thanks very much in advance
>
> > > bmac
>
> > Replace the formula of Text5 with this one - Format(Finish,"ddd mm/dd/
> > yy ") & Text4
>
> > Please let us know if this satisfies your requiremnet.
>
> > - Sai, PMP, PMI-SP, MCT, MCTS
> >http://saipower.wordpress.com
> > .- Hide quoted text -
>
> - Show quoted text -

Welcome
 | 
Pages: 1
Prev: Project Printing Issues
Next: Redistribution Resources problem