| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
date switch/format
Is there a switch that can change a date format from "yyyymmdd" to "month
day, year"? An example of the data and what I would like it to look like when it is printed: 20081125 to read November 25, 2008 |
|
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
date switch/format
Hi BJ,
Here's one way, using a set of nested fields coded as: {QUOTE{={FILLIN "Input the Date in YYYYMMDD format."} \# "0000'-'00'-'00" } \@ "MMMM, D YYYY"} After creating the field, select it & press F9. Then follow the prompt. Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. If you press Ctrl-F9 three times, you'll get three nested fields (ie '{ { { } } }'), which you can the add the text to as shown above. -- Cheers macropod [MVP - Microsoft Word] "BJ" wrote in message ... Is there a switch that can change a date format from "yyyymmdd" to "month day, year"? An example of the data and what I would like it to look like when it is printed: 20081125 to read November 25, 2008 |
|
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
date switch/format
How do I link that formula to a database so it changes with the records?
"macropod" wrote: Hi BJ, Here's one way, using a set of nested fields coded as: {QUOTE{={FILLIN "Input the Date in YYYYMMDD format."} \# "0000'-'00'-'00" } \@ "MMMM, D YYYY"} After creating the field, select it & press F9. Then follow the prompt. Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. If you press Ctrl-F9 three times, you'll get three nested fields (ie '{ { { } } }'), which you can the add the text to as shown above. -- Cheers macropod [MVP - Microsoft Word] "BJ" wrote in message ... Is there a switch that can change a date format from "yyyymmdd" to "month day, year"? An example of the data and what I would like it to look like when it is printed: 20081125 to read November 25, 2008 |
|
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
date switch/format
Hi BJ,
I take it this is for a mailmerge. You didn't mention that before. In that case you could use a field construction like: {QUOTE{MERGEFIELD MyDate \# "0000'-'00'-'00" } \@ "MMMM, D YYYY"} where 'MyDate' is the name of the date field in your database. -- Cheers macropod [MVP - Microsoft Word] "BJ" wrote in message ... How do I link that formula to a database so it changes with the records? "macropod" wrote: Hi BJ, Here's one way, using a set of nested fields coded as: {QUOTE{={FILLIN "Input the Date in YYYYMMDD format."} \# "0000'-'00'-'00" } \@ "MMMM, D YYYY"} After creating the field, select it & press F9. Then follow the prompt. Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. If you press Ctrl-F9 three times, you'll get three nested fields (ie '{ { { } } }'), which you can the add the text to as shown above. -- Cheers macropod [MVP - Microsoft Word] "BJ" wrote in message ... Is there a switch that can change a date format from "yyyymmdd" to "month day, year"? An example of the data and what I would like it to look like when it is printed: 20081125 to read November 25, 2008 |
|
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
date switch/format
Excellant.......thanks for your help, I appreciate it.
BJ "macropod" wrote: Hi BJ, I take it this is for a mailmerge. You didn't mention that before. In that case you could use a field construction like: {QUOTE{MERGEFIELD MyDate \# "0000'-'00'-'00" } \@ "MMMM, D YYYY"} where 'MyDate' is the name of the date field in your database. -- Cheers macropod [MVP - Microsoft Word] "BJ" wrote in message ... How do I link that formula to a database so it changes with the records? "macropod" wrote: Hi BJ, Here's one way, using a set of nested fields coded as: {QUOTE{={FILLIN "Input the Date in YYYYMMDD format."} \# "0000'-'00'-'00" } \@ "MMMM, D YYYY"} After creating the field, select it & press F9. Then follow the prompt. Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. If you press Ctrl-F9 three times, you'll get three nested fields (ie '{ { { } } }'), which you can the add the text to as shown above. -- Cheers macropod [MVP - Microsoft Word] "BJ" wrote in message ... Is there a switch that can change a date format from "yyyymmdd" to "month day, year"? An example of the data and what I would like it to look like when it is printed: 20081125 to read November 25, 2008 |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Switch, Blank Lines & Columns | Mailmerge | |||
| how do I switch off automatic insertion of date in Word 2007 Beta | Microsoft Word Help | |||
| Mail Merge Date Switch Problems | Mailmerge | |||
| How do I enter a future date with a switch? I always need to hav. | Microsoft Word Help | |||
| How do I enter a future date with a switch? I always need to hav. | Microsoft Word Help | |||
Linear Mode
