michaeldi
asked on
Mail Marge to display date differently to 12/09/08
Mail merge in word natrually displays 31/01/2007 however I would actually like to display the date as follows
Thursday 31st January.
It is getting the information from a very simple access database. I know you can right click and edit the field format from within word but I cant work out how you can get it to display like above.
Please help.
Mick
Thursday 31st January.
It is getting the information from a very simple access database. I know you can right click and edit the field format from within word but I cant work out how you can get it to display like above.
Please help.
Mick
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
its actually gong to be \@ dddd dd MMMM yyyy
to get it in the format specified.
to get it in the format specified.
The format KCTS specified, will add the year, which it looked like you didn't want.
Hey, I found a really helpful site at this page:
http://www.gmayor.com/formatting_word_fields.htm
Scroll down to the section "Date fields with ordinals" and it gives you syntax to address adding the st, rd, nd (that I missed in your original question!).
If you have questions of us, please just ask!
Hey, I found a really helpful site at this page:
http://www.gmayor.com/formatting_word_fields.htm
Scroll down to the section "Date fields with ordinals" and it gives you syntax to address adding the st, rd, nd (that I missed in your original question!).
If you have questions of us, please just ask!
Opps sorry - my mistake - must put my galsses on 8-)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
michaeldi,
The only other option I can think of is...
If this format is what you want all the time...
Then perhaps it would be best to change the "Source" to be formatted as dddd dd MMMM yyyy, so as to avoid converting it every time.
This is easiest if the Data is in Excel, simply highlight the date Field and click: Format-->Cells.
Then Select "Date" from the Category section... there will be a Date format listed that is similar to what you want.
In Access, open the source table in design view, select the Date field.
Near the bottom of the screen you will see a property called "Format".
You will select: "Long Date"
The good news is that in either program you can literally type in the format directly.
HTH as well
JeffCoachman
The only other option I can think of is...
If this format is what you want all the time...
Then perhaps it would be best to change the "Source" to be formatted as dddd dd MMMM yyyy, so as to avoid converting it every time.
This is easiest if the Data is in Excel, simply highlight the date Field and click: Format-->Cells.
Then Select "Date" from the Category section... there will be a Date format listed that is similar to what you want.
In Access, open the source table in design view, select the Date field.
Near the bottom of the screen you will see a property called "Format".
You will select: "Long Date"
The good news is that in either program you can literally type in the format directly.
HTH as well
JeffCoachman
The default transfer method (ODBC) does not copy the formatting options in Excel or Access, but works with the underlying data only. Changing the display format in those two applications will not normally make any difference to the mail merge formatting.
You would have to force a DDE transfer (the default in Office 97)
You would have to force a DDE transfer (the default in Office 97)
GrahamSkan,
oops, sorry, you are correct.
I was thinking about Queries/Tables to Reports.
:(
JeffCoachman
oops, sorry, you are correct.
I was thinking about Queries/Tables to Reports.
:(
JeffCoachman
Don't be sorry, Jeff.
That fact is not generally known - it's not in the Help documentation - and we are all here to learn.
That fact is not generally known - it's not in the Help documentation - and we are all here to learn.
GrahamSkan,
So true.
:)
<OT>
You should more time with us over in the Access TA!
:)
How are you liking Office 2007?
JeffCoachman
So true.
:)
<OT>
You should more time with us over in the Access TA!
:)
How are you liking Office 2007?
JeffCoachman
ASKER
Thank you for your answer. I was able to do it but given up on getting the nd, th st etc on the end.
to be honest, I don't know how to get the nd rd or st....