Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Date Format (Office 97)

    Can anyone suggest a format for a Date field which will give me :-
    '7th March, 2002'

    Can get '7 March 2002' or '07 March 2002' but cant get the 'th' after the 7 or the comma. I guess I would like 'nd' after 2 or 'rd' after 3 also.

    TIA
    <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

  2. #2
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: Date Format (Office 97)

    There's an ordinal switch that you can use in the field. I couldn't work out how to get this to function in one field, but if you don't mind using two back to back, it should work.

    This:

    { DATE @ "d" * Ordinal }{ DATE @ "MMMM, yyyy" }

    produces

    6th March, 2002

    Gary

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Date Format (Office 97)

    Thanks Gary,

    Tried this using SAVEDATE and DATE. I cut and paste direct from your post. Had problems with the field starting with a brace ( { ), OK button was dimmed until I removed or moved brace to just before first ' ' character. Tried a few variations but.....Got error message

    "Error! Too many picture switches defined."

    I guess the problem is not important enough on which to spend too much time, so unless I goofed implementing your solution, I guess the reader of my document will still be able to tell what the date is, unless he/she is a government employee, in which case nothing will help.

    Thanks anyway.

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Date Format (Office 97)

    On the chance that you are new to the fields business, the braces need to be inserted using Ctrl+F9.

  5. #5
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Date Format (Office 97)

    KER CHING !!!!!!!

    {Light Goes On} Slaps forehead as solution penetrates fogged mind so early in the morning. Solved by inserting two date fields with comma and space delimiter


    Many Thanks Gary
    Many Thanks Gary

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •