Reply
 
Thread Tools Display Modes
  #1   Report Post  
Neil Howie
 
Posts: n/a
Default 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   Report Post  
Greg Maxey
 
Posts: n/a
Default

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   Report Post  
Neil Howie
 
Posts: n/a
Default

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   Report Post  
Charles Kenyon
 
Posts: n/a
Default

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   Report Post  
Greg Maxey
 
Posts: n/a
Default

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   Report Post  
Neil Howie
 
Posts: n/a
Default

Done! Many thanks.

--
Neil

Anti-spam - Domain is really oakleaf ~ idps ~ co ~ uk (change ~ to dot)

|


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert source texts into multiple files and update automatically robfer Microsoft Word Help 9 September 12th 07 10:10 PM
Date Formula in a Field Thomas M Microsoft Word Help 4 April 25th 05 03:58 PM
Word 2000 formula field gywnfryd Microsoft Word Help 5 March 1st 05 05:21 PM
Text Form Field Ref in Footer Won't Update on Screen StarWine Microsoft Word Help 3 December 6th 04 06:17 PM
field formula Jessica Tables 1 December 2nd 04 11:46 PM


All times are GMT +1. The time now is 03:54 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"