Date Format.

[sam]

Hi All,

I need a small help with regard to the date format.
I need the date in the format of Wed 08/12/08 (In the available
formats,the nearest format to this exampel is Wed 8/12/08 , thus
missing 0 in the day)

I am using MS Project 2007.

Thanks for the help in advance.

SAM

 

[Jan De Messemaeker]

Hi,

If this is about a well defined number of day fields, one could write a VBA
macro to produce what you want in a Text field (if the length of the string
is 11 insert a 0 in place 5) but automatically for all dates Project will
produce, no, sorry.
Hope this helps

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Rod Gill]

Your only choices are those defined by the regional settings in windows and
then in Tools, Options in Project. Try adjusting your regional settings in
the Control Panel and set a custom format for your dates.

This may affect how dates are displayed by default in other programs.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Steve House]

In the Windows Control Panel, Region setup, Date settings make sure the sort
date format is dd/mm/yy. The two d's causes day numbers < 10 to display
with a leading zero.

 

[sam]

In the Windows Control Panel, Region setup, Date settings make sure the sort
date format is dd/mm/yy.  The two d's causes day numbers < 10 to display
with a leading zero.
--
Steve House [Project MVP]
MS Project Trainer & Consultant
Visithttp://project.mvps.org/faqs.htmfor the FAQs

Hi All,

I need a small help with regard to the date format.
I need the date in the format of Wed 08/12/08 (In the available
formats,the nearest format to this exampel is Wed 8/12/08 , thus
missing 0 in the day)

I am using MS Project 2007.

Thanks for the help in advance.

SAM- Hide quoted text -

- Show quoted text -

Thanks for the inputs.
I have changed the format in regionla settings and Bingo!!! it
reflected in MS Project

 

[Brian Lukanic]

Rod,

Is there any way to create a formula/view in a custom date field to display
european date format instead of changing global PC settings in the control
panel? Reason this is preferred is because I toggle between man US-based
Project scheules and one EMEA-based Project schedule.
Brian Lukanic
Chicago, IL

 

[Steve House]

No need ... open you Project file on a machine configured for US region
settings and the dates appear in Month/Day/Year order. Move the file to a
machine set for European regional settings and when you open it the dates
magically appear in Day/Month/Year order. The actual date data is a Julian
date decimal value - the appearance is merely a matter of formatting on the
machine in use at the moment.

 

[JulieS]

Hello Brian,

If it is just for display purposes, you can format a date field in a
custom text field (Text1 for instance) with

Format ([Finish], "dd-mm-yyyy")

Finish field would now show the US format and the text field would
show a format used elsewhere. Any calculations would continue to
reference the actual Finish field.

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