M
MKincaid
How do I generate a custom field that is a combination of two other fields
that already exist?
that already exist?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jim Aksel
It depends on the type of field. For example, Text1 might concatenate the
Finish Date and the Baseline Finish. It would look like this:
[Finish] + " Baseline: " + [Baseline Finish]
11/03/2008 Baseline: 11/15/2008
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
Finish Date and the Baseline Finish. It would look like this:
[Finish] + " Baseline: " + [Baseline Finish]
11/03/2008 Baseline: 11/15/2008
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
M
MKincaid
Thanks, Text is exactly what I needed to concantonate
--
Milo
--
Milo
Jim Aksel said:It depends on the type of field. For example, Text1 might concatenate the
Finish Date and the Baseline Finish. It would look like this:
[Finish] + " Baseline: " + [Baseline Finish]
11/03/2008 Baseline: 11/15/2008
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
MKincaid said:How do I generate a custom field that is a combination of two other fields
that already exist?
J
Jim Aksel
You are welcome; thank you for the feedback.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
MKincaid said:Thanks, Text is exactly what I needed to concantonate
--
Milo
Jim Aksel said:It depends on the type of field. For example, Text1 might concatenate the
Finish Date and the Baseline Finish. It would look like this:
[Finish] + " Baseline: " + [Baseline Finish]
11/03/2008 Baseline: 11/15/2008
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
MKincaid said:How do I generate a custom field that is a combination of two other fields
that already exist?
T
Tom Mc
I am trying to do the same thing, but it displays in minutes, i.e., 1/1/10
5:00:00 PM. I just want the date. How do I remove the rest?
Thanks - Tom
5:00:00 PM. I just want the date. How do I remove the rest?
Thanks - Tom
Jim Aksel said:You are welcome; thank you for the feedback.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
MKincaid said:Thanks, Text is exactly what I needed to concantonate
--
Milo
Jim Aksel said:It depends on the type of field. For example, Text1 might concatenate the
Finish Date and the Baseline Finish. It would look like this:
[Finish] + " Baseline: " + [Baseline Finish]
11/03/2008 Baseline: 11/15/2008
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
How do I generate a custom field that is a combination of two other fields
that already exist?
R
Rob Schneider
Isn't it just a matter of removing the the time from date display, e.g.
Menu: Tools/Options, Tab: View, see "Date Format" and pick on that you
like that does not have time.
--rms
www.rmschneider.com
Menu: Tools/Options, Tab: View, see "Date Format" and pick on that you
like that does not have time.
--rms
www.rmschneider.com
I am trying to do the same thing, but it displays in minutes, i.e., 1/1/10
5:00:00 PM. I just want the date. How do I remove the rest?
Thanks - Tom
Jim Aksel said:You are welcome; thank you for the feedback.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
MKincaid said:Thanks, Text is exactly what I needed to concantonate
--
Milo
:
It depends on the type of field. For example, Text1 might concatenate the
Finish Date and the Baseline Finish. It would look like this:
[Finish] + " Baseline: " + [Baseline Finish]
11/03/2008 Baseline: 11/15/2008
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
How do I generate a custom field that is a combination of two other fields
that already exist?
T
Tom Mc
I thought that too, but that doesn't solve it. I've already got the View set
to "mm/dd/yy" format - but, apparently, when used in a formula, the whole
thing displays. Any other suggestions? Thx!
to "mm/dd/yy" format - but, apparently, when used in a formula, the whole
thing displays. Any other suggestions? Thx!
Rob Schneider said:Isn't it just a matter of removing the the time from date display, e.g.
Menu: Tools/Options, Tab: View, see "Date Format" and pick on that you
like that does not have time.
--rms
www.rmschneider.com
.I am trying to do the same thing, but it displays in minutes, i.e., 1/1/10
5:00:00 PM. I just want the date. How do I remove the rest?
Thanks - Tom
Jim Aksel said:You are welcome; thank you for the feedback.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
Thanks, Text is exactly what I needed to concantonate
--
Milo
:
It depends on the type of field. For example, Text1 might concatenate the
Finish Date and the Baseline Finish. It would look like this:
[Finish] + " Baseline: " + [Baseline Finish]
11/03/2008 Baseline: 11/15/2008
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
How do I generate a custom field that is a combination of two other fields
that already exist?
R
Rob Schneider
I don't have Project at hand to experiment. Thoughts:
1. is the field a custom date/time field, or is it text?
a. If text, you can use the format() function to display the format.
b. If text, why? do it as a date field and then see if the view setting
affects it's display?
(all I can think of at the moment).
--rms
www.rmschneider.com
1. is the field a custom date/time field, or is it text?
a. If text, you can use the format() function to display the format.
b. If text, why? do it as a date field and then see if the view setting
affects it's display?
(all I can think of at the moment).
--rms
www.rmschneider.com
I thought that too, but that doesn't solve it. I've already got the View set
to "mm/dd/yy" format - but, apparently, when used in a formula, the whole
thing displays. Any other suggestions? Thx!
Rob Schneider said:Isn't it just a matter of removing the the time from date display, e.g.
Menu: Tools/Options, Tab: View, see "Date Format" and pick on that you
like that does not have time.
--rms
www.rmschneider.com
.I am trying to do the same thing, but it displays in minutes, i.e., 1/1/10
5:00:00 PM. I just want the date. How do I remove the rest?
Thanks - Tom
:
You are welcome; thank you for the feedback.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
Thanks, Text is exactly what I needed to concantonate
--
Milo
:
It depends on the type of field. For example, Text1 might concatenate the
Finish Date and the Baseline Finish. It would look like this:
[Finish] + " Baseline: " + [Baseline Finish]
11/03/2008 Baseline: 11/15/2008
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
How do I generate a custom field that is a combination of two other fields
that already exist?
B
Barbara - Austria
Datevalue() takes Date format from Tools->Options.
So Datevalue([Finish]) & " Baseline: " & Datevalue([Baseline Finish])
will show, what you want to display, depending on the cosen "Date Format".
Regards
Barbara
Am 01.03.2010 18:58, schrieb Tom Mc:
So Datevalue([Finish]) & " Baseline: " & Datevalue([Baseline Finish])
will show, what you want to display, depending on the cosen "Date Format".
Regards
Barbara
Am 01.03.2010 18:58, schrieb Tom Mc:
I thought that too, but that doesn't solve it. I've already got the View set
to "mm/dd/yy" format - but, apparently, when used in a formula, the whole
thing displays. Any other suggestions? Thx!
Rob Schneider said:Isn't it just a matter of removing the the time from date display, e.g.
Menu: Tools/Options, Tab: View, see "Date Format" and pick on that you
like that does not have time.
--rms
www.rmschneider.com
.I am trying to do the same thing, but it displays in minutes, i.e., 1/1/10
5:00:00 PM. I just want the date. How do I remove the rest?
Thanks - Tom
:
You are welcome; thank you for the feedback.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
Thanks, Text is exactly what I needed to concantonate
--
Milo
:
It depends on the type of field. For example, Text1 might concatenate the
Finish Date and the Baseline Finish. It would look like this:
[Finish] + " Baseline: " + [Baseline Finish]
11/03/2008 Baseline: 11/15/2008
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
How do I generate a custom field that is a combination of two other fields
that already exist?
T
Tom Mc
I've tried both date and text fields without success. I'm not sure about the
syntax for the format() function. Can you insert that into the following
expression for me?
[Start] & '-' & [Finish]
Thanks again!
syntax for the format() function. Can you insert that into the following
expression for me?
[Start] & '-' & [Finish]
Thanks again!
Rob Schneider said:I don't have Project at hand to experiment. Thoughts:
1. is the field a custom date/time field, or is it text?
a. If text, you can use the format() function to display the format.
b. If text, why? do it as a date field and then see if the view setting
affects it's display?
(all I can think of at the moment).
--rms
www.rmschneider.com
.I thought that too, but that doesn't solve it. I've already got the View set
to "mm/dd/yy" format - but, apparently, when used in a formula, the whole
thing displays. Any other suggestions? Thx!
Rob Schneider said:Isn't it just a matter of removing the the time from date display, e.g.
Menu: Tools/Options, Tab: View, see "Date Format" and pick on that you
like that does not have time.
--rms
www.rmschneider.com
On 01/03/10 16:11, Tom Mc wrote:
I am trying to do the same thing, but it displays in minutes, i.e., 1/1/10
5:00:00 PM. I just want the date. How do I remove the rest?
Thanks - Tom
:
You are welcome; thank you for the feedback.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
Thanks, Text is exactly what I needed to concantonate
--
Milo
:
It depends on the type of field. For example, Text1 might concatenate the
Finish Date and the Baseline Finish. It would look like this:
[Finish] + " Baseline: " + [Baseline Finish]
11/03/2008 Baseline: 11/15/2008
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
How do I generate a custom field that is a combination of two other fields
that already exist?
T
Tom Mc
That works for displaying "m/d/yyyy" format - i.e., the hrs & mins are
removed. Thanks! How about if I just want to display "m/d". That is what I
really want to display. Even if I define "m/d" in Tools/Options/View/Date
Format field it still displays "m/d/yyyy". We're almost there! Thanks to
both Rob and Barbara!
removed. Thanks! How about if I just want to display "m/d". That is what I
really want to display. Even if I define "m/d" in Tools/Options/View/Date
Format field it still displays "m/d/yyyy". We're almost there! Thanks to
both Rob and Barbara!
Barbara - Austria said:Datevalue() takes Date format from Tools->Options.
So Datevalue([Finish]) & " Baseline: " & Datevalue([Baseline Finish])
will show, what you want to display, depending on the cosen "Date Format".
Regards
Barbara
Am 01.03.2010 18:58, schrieb Tom Mc:.I thought that too, but that doesn't solve it. I've already got the View set
to "mm/dd/yy" format - but, apparently, when used in a formula, the whole
thing displays. Any other suggestions? Thx!
Rob Schneider said:Isn't it just a matter of removing the the time from date display, e.g.
Menu: Tools/Options, Tab: View, see "Date Format" and pick on that you
like that does not have time.
--rms
www.rmschneider.com
On 01/03/10 16:11, Tom Mc wrote:
I am trying to do the same thing, but it displays in minutes, i.e., 1/1/10
5:00:00 PM. I just want the date. How do I remove the rest?
Thanks - Tom
:
You are welcome; thank you for the feedback.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
Thanks, Text is exactly what I needed to concantonate
--
Milo
:
It depends on the type of field. For example, Text1 might concatenate the
Finish Date and the Baseline Finish. It would look like this:
[Finish] + " Baseline: " + [Baseline Finish]
11/03/2008 Baseline: 11/15/2008
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
How do I generate a custom field that is a combination of two other fields
that already exist?
B
Barbara - Austria
I have just realized, that date format from options is only taken if
there is no '&' included ... interesting. (It is working for
Datevalue([Finish]) and hitting F9 after format change, it is not
working for my example - sorry. I have only tested the first part.)
If you only need month and day, take this one:
Month([Start]) & "/" & Day([Start]) & "-" & Month([Finish]) & "/" &
Day([Finish])
Does that work?
Regards
Barbara
Am 01.03.2010 20:35, schrieb Tom Mc:
there is no '&' included ... interesting. (It is working for
Datevalue([Finish]) and hitting F9 after format change, it is not
working for my example - sorry. I have only tested the first part.)
If you only need month and day, take this one:
Month([Start]) & "/" & Day([Start]) & "-" & Month([Finish]) & "/" &
Day([Finish])
Does that work?
Regards
Barbara
Am 01.03.2010 20:35, schrieb Tom Mc:
That works for displaying "m/d/yyyy" format - i.e., the hrs& mins are
removed. Thanks! How about if I just want to display "m/d". That is what I
really want to display. Even if I define "m/d" in Tools/Options/View/Date
Format field it still displays "m/d/yyyy". We're almost there! Thanks to
both Rob and Barbara!
Barbara - Austria said:Datevalue() takes Date format from Tools->Options.
So Datevalue([Finish])& " Baseline: "& Datevalue([Baseline Finish])
will show, what you want to display, depending on the cosen "Date Format".
Regards
Barbara
Am 01.03.2010 18:58, schrieb Tom Mc:.I thought that too, but that doesn't solve it. I've already got the View set
to "mm/dd/yy" format - but, apparently, when used in a formula, the whole
thing displays. Any other suggestions? Thx!
:
Isn't it just a matter of removing the the time from date display, e.g.
Menu: Tools/Options, Tab: View, see "Date Format" and pick on that you
like that does not have time.
--rms
www.rmschneider.com
On 01/03/10 16:11, Tom Mc wrote:
I am trying to do the same thing, but it displays in minutes, i.e., 1/1/10
5:00:00 PM. I just want the date. How do I remove the rest?
Thanks - Tom
:
You are welcome; thank you for the feedback.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
Thanks, Text is exactly what I needed to concantonate
--
Milo
:
It depends on the type of field. For example, Text1 might concatenate the
Finish Date and the Baseline Finish. It would look like this:
[Finish] + " Baseline: " + [Baseline Finish]
11/03/2008 Baseline: 11/15/2008
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
How do I generate a custom field that is a combination of two other fields
that already exist?
T
Tom Mc
Works like a charm! Thanks Barbara!
Barbara - Austria said:I have just realized, that date format from options is only taken if
there is no '&' included ... interesting. (It is working for
Datevalue([Finish]) and hitting F9 after format change, it is not
working for my example - sorry. I have only tested the first part.)
If you only need month and day, take this one:
Month([Start]) & "/" & Day([Start]) & "-" & Month([Finish]) & "/" &
Day([Finish])
Does that work?
Regards
Barbara
Am 01.03.2010 20:35, schrieb Tom Mc:.That works for displaying "m/d/yyyy" format - i.e., the hrs& mins are
removed. Thanks! How about if I just want to display "m/d". That is what I
really want to display. Even if I define "m/d" in Tools/Options/View/Date
Format field it still displays "m/d/yyyy". We're almost there! Thanks to
both Rob and Barbara!
Barbara - Austria said:Datevalue() takes Date format from Tools->Options.
So Datevalue([Finish])& " Baseline: "& Datevalue([Baseline Finish])
will show, what you want to display, depending on the cosen "Date Format".
Regards
Barbara
Am 01.03.2010 18:58, schrieb Tom Mc:
I thought that too, but that doesn't solve it. I've already got the View set
to "mm/dd/yy" format - but, apparently, when used in a formula, the whole
thing displays. Any other suggestions? Thx!
:
Isn't it just a matter of removing the the time from date display, e.g.
Menu: Tools/Options, Tab: View, see "Date Format" and pick on that you
like that does not have time.
--rms
www.rmschneider.com
On 01/03/10 16:11, Tom Mc wrote:
I am trying to do the same thing, but it displays in minutes, i.e., 1/1/10
5:00:00 PM. I just want the date. How do I remove the rest?
Thanks - Tom
:
You are welcome; thank you for the feedback.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
Thanks, Text is exactly what I needed to concantonate
--
Milo
:
It depends on the type of field. For example, Text1 might concatenate the
Finish Date and the Baseline Finish. It would look like this:
[Finish] + " Baseline: " + [Baseline Finish]
11/03/2008 Baseline: 11/15/2008
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
How do I generate a custom field that is a combination of two other fields
that already exist?
--
Milo
.
.
J
Jack Dahlgren MVP
You can always use the Format command to get what you want. It is a bit
easier than working out month and day separately. Try this:
Format([Start],"m/d") & "-" & Format([Finish],"m/d")
instead of this
Month([Start]) & "/" & Day([Start]) & "-" & Month([Finish]) & "/" &
Day([Finish])
-Jack Dahlgren
easier than working out month and day separately. Try this:
Format([Start],"m/d") & "-" & Format([Finish],"m/d")
instead of this
Month([Start]) & "/" & Day([Start]) & "-" & Month([Finish]) & "/" &
Day([Finish])
-Jack Dahlgren
Barbara - Austria said:I have just realized, that date format from options is only taken if there
is no '&' included ... interesting. (It is working for Datevalue([Finish])
and hitting F9 after format change, it is not working for my example -
sorry. I have only tested the first part.)
If you only need month and day, take this one:
Month([Start]) & "/" & Day([Start]) & "-" & Month([Finish]) & "/" &
Day([Finish])
Does that work?
Regards
Barbara
Am 01.03.2010 20:35, schrieb Tom Mc:That works for displaying "m/d/yyyy" format - i.e., the hrs& mins are
removed. Thanks! How about if I just want to display "m/d". That is
what I
really want to display. Even if I define "m/d" in
Tools/Options/View/Date
Format field it still displays "m/d/yyyy". We're almost there! Thanks
to
both Rob and Barbara!
Barbara - Austria said:Datevalue() takes Date format from Tools->Options.
So Datevalue([Finish])& " Baseline: "& Datevalue([Baseline Finish])
will show, what you want to display, depending on the cosen "Date
Format".
Regards
Barbara
Am 01.03.2010 18:58, schrieb Tom Mc:
I thought that too, but that doesn't solve it. I've already got the
View set
to "mm/dd/yy" format - but, apparently, when used in a formula, the
whole
thing displays. Any other suggestions? Thx!
:
Isn't it just a matter of removing the the time from date display,
e.g.
Menu: Tools/Options, Tab: View, see "Date Format" and pick on that you
like that does not have time.
--rms
www.rmschneider.com
On 01/03/10 16:11, Tom Mc wrote:
I am trying to do the same thing, but it displays in minutes, i.e.,
1/1/10
5:00:00 PM. I just want the date. How do I remove the rest?
Thanks - Tom
:
You are welcome; thank you for the feedback.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
Thanks, Text is exactly what I needed to concantonate
--
Milo
:
It depends on the type of field. For example, Text1 might
concatenate the
Finish Date and the Baseline Finish. It would look like this:
[Finish] + " Baseline: " + [Baseline Finish]
11/03/2008 Baseline: 11/15/2008
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
How do I generate a custom field that is a combination of two
other fields
that already exist?
--
Milo
.
.
B
Barbara - Austria
Thanks for that! I was quite sure that I had already used Format(), but
I haven't look for it in text functions, only in date (where I expected
it to be placed). With your confirmation that it does still exist, I
looked more carefully.
Am 02.03.2010 17:50, schrieb Jack Dahlgren MVP:
I haven't look for it in text functions, only in date (where I expected
it to be placed). With your confirmation that it does still exist, I
looked more carefully.
Am 02.03.2010 17:50, schrieb Jack Dahlgren MVP:
You can always use the Format command to get what you want. It is a bit
easier than working out month and day separately. Try this:
Format([Start],"m/d") & "-" & Format([Finish],"m/d")
instead of this
Month([Start]) & "/" & Day([Start]) & "-" & Month([Finish]) & "/" &
Day([Finish])
-Jack Dahlgren
Barbara - Austria said:I have just realized, that date format from options is only taken if
there is no '&' included ... interesting. (It is working for
Datevalue([Finish]) and hitting F9 after format change, it is not
working for my example - sorry. I have only tested the first part.)
If you only need month and day, take this one:
Month([Start]) & "/" & Day([Start]) & "-" & Month([Finish]) & "/" &
Day([Finish])
Does that work?
Regards
Barbara
Am 01.03.2010 20:35, schrieb Tom Mc:That works for displaying "m/d/yyyy" format - i.e., the hrs& mins are
removed. Thanks! How about if I just want to display "m/d". That is
what I
really want to display. Even if I define "m/d" in
Tools/Options/View/Date
Format field it still displays "m/d/yyyy". We're almost there! Thanks to
both Rob and Barbara!
:
Datevalue() takes Date format from Tools->Options.
So Datevalue([Finish])& " Baseline: "& Datevalue([Baseline Finish])
will show, what you want to display, depending on the cosen "Date
Format".
Regards
Barbara
Am 01.03.2010 18:58, schrieb Tom Mc:
I thought that too, but that doesn't solve it. I've already got the
View set
to "mm/dd/yy" format - but, apparently, when used in a formula, the
whole
thing displays. Any other suggestions? Thx!
:
Isn't it just a matter of removing the the time from date display,
e.g.
Menu: Tools/Options, Tab: View, see "Date Format" and pick on that
you
like that does not have time.
--rms
www.rmschneider.com
On 01/03/10 16:11, Tom Mc wrote:
I am trying to do the same thing, but it displays in minutes,
i.e., 1/1/10
5:00:00 PM. I just want the date. How do I remove the rest?
Thanks - Tom
:
You are welcome; thank you for the feedback.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
Thanks, Text is exactly what I needed to concantonate
--
Milo
:
It depends on the type of field. For example, Text1 might
concatenate the
Finish Date and the Baseline Finish. It would look like this:
[Finish] + " Baseline: " + [Baseline Finish]
11/03/2008 Baseline: 11/15/2008
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
:
How do I generate a custom field that is a combination of two
other fields
that already exist?
--
Milo
.
.
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.