ms visio 2003 how to change date format in header and footer

Posted on 2006-05-29
Last Modified: 2008-01-09
I have a Visio document that needs to have the date displayed in the footer but not in 'mm/dd/yyy' format. Date needs to be displayed 'dd/mm/yyyy'.

Question by:deNZity
    LVL 44

    Accepted Solution

    Hi deNZity,

    this is by design and pretty annoying according to


    c. Date and time values inserted in Header and Footer
    Microsoft Visio 2003 uses the language file setting to display the date and time values used in header and footer. For example, when you adjust the language file setting to be Arabic (Saudi Arabic) and set the long date to be displayed in the header, Visio 2003 will display the value in Arabic text. The calendar used in this example will be the Gregorian calendar with Arabic month names.

    share what you know, learn what you don't
    LVL 80

    Assisted Solution

    Hi deNZity,
    You can put the date in the footer using a macro in any format you desire:

    Sub DateInFooter()
    ActiveDocument.FooterLeft = Format(Date, "dd/mm/yyyy")
    End Sub

    Hoping to be helpful,

    LVL 18

    Expert Comment

    To change from mm/dd/yyyy to dd/mm/yyyy set it in the regional settings of Windows, by choosing a country with that order (Portuguese Brazil, for instance).
    This will affect data format of all your applications.

    LVL 1

    Expert Comment

    If it is just a single document I would suggest just typing the date in manually.

    You can also modify the current regional settings for Windows. In XP, Start, Run, type intl.cpl  click OK. Beside your selected Region, click Customize, click the date tab, change the short date format. Only caveat here is that if someone else makes a change I believe it will update the footer to match their regional settings.

    Author Comment

    Thanks for the replies. I had already tried the regional settings without any luck.

    I didnt try creating a macro just put the date into a shape, date didn't have to be dynamic.

    will share points between byundt and bruintje if ok with everyone.


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Best Online Bookmark Organiser 6 54
    Norton antivirus 11 60
    People Counting Software 2 31
    Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
    Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
    This video will demonstrate how to find the puppet warp tool from the edit menu and where to put the points to edit.
    The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now