Date Calculation Field Formatting Issues

G

Guest

I have a date caluclation field which has formatting switch \@ "dd/MM/yy" yet
my dates show up as MM/dd/yy (in some documents)

My language settings on the computer are set to English (Australia)

This is driving me insane!!!
 
D

Doug Robbins - Word MVP

I am not sure from where you are getting the dates, but see the "Dates:
day/month reversed" item under the "Connection methods" topic of the "Mail
merge in Word 2002" section of fellow MVP Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/MergFram.htm

Did you see my latest post in the thread about aligning the $ sign at the
left of the cell and the numbers to the right? I posted a way to do it
there when using a formfield.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
G

Guest

The date is a date calculation field which works the date out based on today
+/- a number of days. And the field is set to show dd/MM/yy and it only
shows MM/dd/yy!???

It's so weird!

I will check out your other post, I had kind of given up on that idea, but
if you've found a way that's fantastic!
 
G

Graham Mayor

Use the macro at http://www.gmayor.com/export_field.htm to copy your field
construction to the clipboard and paste it into your reply so that we can
see what exactly you are trying to do.

There was an issue with date transposition in some versions of Word, though
this was, I believe, corrected in Word 2003 - ensure that your copy is
updated with the latest updates.

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

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

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