Custom date format for text field?

[WeekendScribe]

I am inserting a date field into a shape. In the "FIELD" dialog
(Insert->Field) there are no date formats that enforce leading zeros like
{{mm\dd\yy}}. Also, I cannot enter a custom format into the "Custom Format"
box at the lower right of this dialog. How can I set a custom format for
fields?

(I am running Visio 2003 SP2)

 

[Paul Herber]

I am inserting a date field into a shape. In the "FIELD" dialog
(Insert->Field) there are no date formats that enforce leading zeros like
{{mm\dd\yy}}. Also, I cannot enter a custom format into the "Custom Format"
box at the lower right of this dialog. How can I set a custom format for
fields?

Select a different language when inserting the field. The UK date
fields have leading 0 dates.

 

[Al Edlund]

have you considered formatting the text before you insert it?
al

 

[John Marshall, MVP]

Not easy, but...

Open the shape's shapesheet and add a section for User Defined cells (or add
an entry to the user section)
You can rename the row to something more helpful, I used CreationDate, but
set it's value to
=DOCCREATION()
Create a new cell and set it's value to (I called the row FormattedDate)
=FORMAT(User.CreationDate,"MM/dd/YY")
Close the shapesheet and open the text block for the shape, Chose Insert
Field -->UserDefined Cells -->FormattedDate

If you open the shapesheet with the shape visible, you can play with the
Format to see what happens.

John... Visio MVP

Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm
Visio Wishlist http://www.mvps.org/visio/wish_list.htm