Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Field formula wanted
I have a booklet I print once a year. It currently has the year range
"2004-2005" on the front page. Rather than edit this every year, I would like it automatically updated. I can insert a date function with format "YYYY" for the current year, but how do I update the following year? -- Neil Anti-spam - Domain is really oakleaf ~ idps ~ co ~ uk (change ~ to dot) |
#2
|
|||
|
|||
Neil,
Something like: { Quote { Date \@ YYYY } { =sum({ Date \@ YYYY },1) }} should last you a lifetime. -- Greg Maxey/Word MVP See: http://gregmaxey.mvps.org/word_tips.htm For some helpful tips using Word. Neil Howie wrote: I have a booklet I print once a year. It currently has the year range "2004-2005" on the front page. Rather than edit this every year, I would like it automatically updated. I can insert a date function with format "YYYY" for the current year, but how do I update the following year? |
#3
|
|||
|
|||
Thanks, but despite my best efforts and a fair bit of research, I cannot
make this work. I have tried putting in the square brackets where the insert field wizard suggests and quotes round the YYYY. In the few tries concentrating on the bit after the hyphen, where I've not had a syntax error, I still can't get Word 2000 to add 1. -- Neil Anti-spam - Domain is really oakleaf ~ idps ~ co ~ uk (change ~ to dot) "Greg Maxey" wrote in message ... | Neil, | | Something like: | { Quote { Date \@ YYYY } { =sum({ Date \@ YYYY },1) }} | should last you a lifetime. | | -- | Greg Maxey/Word MVP | See: | http://gregmaxey.mvps.org/word_tips.htm | For some helpful tips using Word. | | Neil Howie wrote: | I have a booklet I print once a year. It currently has the year range | "2004-2005" on the front page. Rather than edit this every year, I | would like it automatically updated. I can insert a date function | with format "YYYY" for the current year, but how do I update the | following year? | | |
#4
|
|||
|
|||
You need curly braces inserted using Ctrl-F9 rather than anything you type.
-- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Neil Howie" wrote in message ... Thanks, but despite my best efforts and a fair bit of research, I cannot make this work. I have tried putting in the square brackets where the insert field wizard suggests and quotes round the YYYY. In the few tries concentrating on the bit after the hyphen, where I've not had a syntax error, I still can't get Word 2000 to add 1. -- Neil Anti-spam - Domain is really oakleaf ~ idps ~ co ~ uk (change ~ to dot) "Greg Maxey" wrote in message ... | Neil, | | Something like: | { Quote { Date \@ YYYY } - { =sum({ Date \@ YYYY },1) }} | should last you a lifetime. | | -- | Greg Maxey/Word MVP | See: | http://gregmaxey.mvps.org/word_tips.htm | For some helpful tips using Word. | | Neil Howie wrote: | I have a booklet I print once a year. It currently has the year range | "2004-2005" on the front page. Rather than edit this every year, I | would like it automatically updated. I can insert a date function | with format "YYYY" for the current year, but how do I update the | following year? | | |
#5
|
|||
|
|||
Try entering the field directly without messing with InsertField.
See: http://gregmaxey.mvps.org/Word_Fields.htm specifically paragraph 3. -- Greg Maxey/Word MVP See: http://gregmaxey.mvps.org/word_tips.htm For some helpful tips using Word. Neil Howie wrote: Thanks, but despite my best efforts and a fair bit of research, I cannot make this work. I have tried putting in the square brackets where the insert field wizard suggests and quotes round the YYYY. In the few tries concentrating on the bit after the hyphen, where I've not had a syntax error, I still can't get Word 2000 to add 1. "Greg Maxey" wrote in message ... Neil, Something like: { Quote { Date \@ YYYY } { =sum({ Date \@ YYYY },1) }} should last you a lifetime. -- Greg Maxey/Word MVP See: http://gregmaxey.mvps.org/word_tips.htm For some helpful tips using Word. Neil Howie wrote: I have a booklet I print once a year. It currently has the year range "2004-2005" on the front page. Rather than edit this every year, I would like it automatically updated. I can insert a date function with format "YYYY" for the current year, but how do I update the following year? |
#6
|
|||
|
|||
Done! Many thanks.
-- Neil Anti-spam - Domain is really oakleaf ~ idps ~ co ~ uk (change ~ to dot) | |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert source texts into multiple files and update automatically | Microsoft Word Help | |||
Date Formula in a Field | Microsoft Word Help | |||
Word 2000 formula field | Microsoft Word Help | |||
Text Form Field Ref in Footer Won't Update on Screen | Microsoft Word Help | |||
field formula | Tables |