Remove time value when displaying Finish value

B

bmac

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
 
S

Sai

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
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finish Variance not calculating correctly 0
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
I need Time Range to return Value 4
hide start finish times in the network diagram 0
PWA 2003 - modify fields in existing view. 5
Need help on formula. 3
Help creating evenly proportioned groups. 0

Top