PC Review


Reply
Thread Tools Rate Thread

Create Date field format

 
 
=?Utf-8?B?TWFyeSBBbm4=?=
Guest
Posts: n/a
 
      3rd Nov 2006
I am using the Create Date field in a fax template and want the format to be,
for example, 3rd November 2006. I can see an option for 3 November 2006 but
not 3rd. Can I amend the field to give the format I want?

I am a sophisticated user but don’t do programming.

 
Reply With Quote
 
 
 
 
Suzanne S. Barnhill
Guest
Posts: n/a
 
      3rd Nov 2006
You'll need two fields for this: { CREATEDATE \@ "d" \*Ordinal } and {
CREATEDATE \@ "MMMM yyyy" }.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Mary Ann" <(E-Mail Removed)> wrote in message
newsB5F9817-BC1E-4273-A05A-(E-Mail Removed)...
> I am using the Create Date field in a fax template and want the format to

be,
> for example, 3rd November 2006. I can see an option for 3 November 2006

but
> not 3rd. Can I amend the field to give the format I want?
>
> I am a sophisticated user but don’t do programming.
>


 
Reply With Quote
 
Graham Mayor
Guest
Posts: n/a
 
      4th Nov 2006
But if you want the ordinal superscripted it gets a whole lot more
complicated - see http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Suzanne S. Barnhill wrote:
> You'll need two fields for this: { CREATEDATE \@ "d" \*Ordinal }
> and { CREATEDATE \@ "MMMM yyyy" }.
>
>
> "Mary Ann" <(E-Mail Removed)> wrote in message
> newsB5F9817-BC1E-4273-A05A-(E-Mail Removed)...
>> I am using the Create Date field in a fax template and want the
>> format to be, for example, 3rd November 2006. I can see an option
>> for 3 November 2006 but not 3rd. Can I amend the field to give the
>> format I want?
>>
>> I am a sophisticated user but don’t do programming.



 
Reply With Quote
 
=?Utf-8?B?TWFyeSBBbm4=?=
Guest
Posts: n/a
 
      6th Nov 2006
Thanks Graham - Plenty to study there!

"Graham Mayor" wrote:

> But if you want the ordinal superscripted it gets a whole lot more
> complicated - see http://www.gmayor.com/formatting_word_fields.htm
>
> --
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor - Word MVP
>
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
> Suzanne S. Barnhill wrote:
> > You'll need two fields for this: { CREATEDATE \@ "d" \*Ordinal }
> > and { CREATEDATE \@ "MMMM yyyy" }.
> >
> >
> > "Mary Ann" <(E-Mail Removed)> wrote in message
> > newsB5F9817-BC1E-4273-A05A-(E-Mail Removed)...
> >> I am using the Create Date field in a fax template and want the
> >> format to be, for example, 3rd November 2006. I can see an option
> >> for 3 November 2006 but not 3rd. Can I amend the field to give the
> >> format I want?
> >>
> >> I am a sophisticated user but don’t do programming.

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Application.ExportXML exports dates in the wrong format or the 1899 date if date field is empty Jennifer Robertson Microsoft Access VBA Modules 4 2nd Apr 2009 02:57 AM
how do I create a Date field format for mm/dd/yyyy (10 digits) =?Utf-8?B?VGhlIEJpZyBLYWh1bmE=?= Microsoft Excel Worksheet Functions 1 26th Oct 2006 05:32 PM
How can I format a date field to force a specific date format? =?Utf-8?B?c3BrZWxseQ==?= Microsoft Access 4 19th Dec 2004 05:37 PM
Export Outlook date field as date/time format to Access database =?Utf-8?B?QmVja3k=?= Microsoft Outlook Discussion 0 2nd Dec 2004 02:49 PM
form field date format with default date Keith G Hicks Microsoft Word Document Management 1 15th Oct 2004 10:54 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:43 AM.