Date format in field codes

T

TD

Hi everybody,

I've got the following createdate field that insists on displaying June 25,
2008 when I want it 25, June 2008.

{CREATEDATE \@ "DD-MMM-YYYY" \* MERGEFORMAT}

What am I doing wrong?

Cheers
 
J

Jay Freedman

TD said:
Hi everybody,

I've got the following createdate field that insists on displaying
June 25, 2008 when I want it 25, June 2008.

{CREATEDATE \@ "DD-MMM-YYYY" \* MERGEFORMAT}

What am I doing wrong?

Cheers

Well, that format won't give you what you want, but it also shouldn't be
giving you what you say it does. What you should be seeing instead, given
that field code, is 25-Jun-2008.

To get your desired format, the field code should be

{CREATEDATE \@ "MMMM DD, YYYY" \* MERGEFORMAT}

or maybe with only one D, so you won't get two digits in dates like July 01,
2008.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
S

StevenM

To: TD,

If you want: "25 June, 2008." Is should read:

{CREATEDATE \@ "DD MMMM, YYYY" \* MERGEFORMAT}

The comma belongs before the year, not after the day (of course, it is
acceptable not to use a comma). So:

25 June 2008
25 June, 2008
June 25 2008
June 25, 2008

But that wasn't causing your problem.

Did you update your field (with F9) after you made your last change?
(Also, did you want 3 or 4 Ms?)

Steven Craig Miller
 
T

TD

Thank you Steven,

I take it that 4 Ms gives the full month name and 3Ms gives a 3 letter
abbreviation. Yes?

Thanks again
 
S

StevenM

TD,

<< I take it that 4 Ms gives the full month name and 3Ms gives a 3 letter
abbreviation. Yes? >>

Yes, that is correct.

Also, DD gives a number from 01 to 31,
but D gives a number from 1 to 31.

Steven Craig Miller
 
T

TD

Thank you Steven
--
TD


StevenM said:
TD,

<< I take it that 4 Ms gives the full month name and 3Ms gives a 3 letter
abbreviation. Yes? >>

Yes, that is correct.

Also, DD gives a number from 01 to 31,
but D gives a number from 1 to 31.

Steven Craig Miller
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top