Format field to not include time

[theintern]

Is there any way to format Finish1 to not include time, just date? I tried
setting Finish2 to equal

projdateconv([Finish1],pjDate_mm_dd_yy)

but that still gave me time (but, ironically, a different time than was in
Finish1, though the same date).

any ideas? I need date and time in everything but Finish1 (or some Finish
field) when i just want date.

thanks
scott

 

[JulieS]

Is there any way to format Finish1 to not include time, just date?
I tried
setting Finish2 to equal

projdateconv([Finish1],pjDate_mm_dd_yy)

but that still gave me time (but, ironically, a different time than
was in
Finish1, though the same date).

any ideas? I need date and time in everything but Finish1 (or some
Finish
field) when i just want date.

thanks
scott

Hello Scott,

The formula you site works fine in a Text field as does:

Format ([Finish1], "mm/dd/yy")

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

 

[theintern]

yes, that works, and is a valid answer to my solution. however, i should
have included that i need to put a marker on the Gantt for this date, and i
can't format the bar style to trigger on a Text field. any other ideas?

thanks Julie
scott

Is there any way to format Finish1 to not include time, just date?
I tried
setting Finish2 to equal

projdateconv([Finish1],pjDate_mm_dd_yy)

but that still gave me time (but, ironically, a different time than
was in
Finish1, though the same date).

any ideas? I need date and time in everything but Finish1 (or some
Finish
field) when i just want date.

thanks
scott

Hello Scott,

The formula you site works fine in a Text field as does:

Format ([Finish1], "mm/dd/yy")

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

 

[theintern]

or i could just keep Finish1, have it trigger on that so it goes on the Gantt
chart, and using Text1 to show the date. Genius. So i guess we're all good.
Thanks!

Scott

Is there any way to format Finish1 to not include time, just date?
I tried
setting Finish2 to equal

projdateconv([Finish1],pjDate_mm_dd_yy)

but that still gave me time (but, ironically, a different time than
was in
Finish1, though the same date).

any ideas? I need date and time in everything but Finish1 (or some
Finish
field) when i just want date.

thanks
scott

Hello Scott,

The formula you site works fine in a Text field as does:

Format ([Finish1], "mm/dd/yy")

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

 

[JulieS]

You're welcome Scott. Glad to see you found the solution to the Gantt
chart issue as well.
Julie

or i could just keep Finish1, have it trigger on that so it goes on
the Gantt
chart, and using Text1 to show the date. Genius. So i guess we're
all good.
Thanks!

Scott

Is there any way to format Finish1 to not include time, just
date?
I tried
setting Finish2 to equal

projdateconv([Finish1],pjDate_mm_dd_yy)

but that still gave me time (but, ironically, a different time
than
was in
Finish1, though the same date).

any ideas? I need date and time in everything but Finish1 (or
some
Finish
field) when i just want date.

thanks
scott

Hello Scott,

The formula you site works fine in a Text field as does:

Format ([Finish1], "mm/dd/yy")

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