Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Bill
 
Posts: n/a
Default Calculate Age in table from Date of Birth and Current Date (MSWord

Is this possible in a Word table?
  #2   Report Post  
Posted to microsoft.public.word.tables
macropod
 
Posts: n/a
Default Calculate Age in table from Date of Birth and Current Date (MSWord

Hi Bill,

To see how to do this and just about everything else you might want to do
with dates in Word, check out my Date Calc 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=249902

Cheers


"Bill" wrote in message
...
Is this possible in a Word table?



  #3   Report Post  
Posted to microsoft.public.word.tables
Needs directcion
 
Posts: n/a
Default Calculate Age in table from Date of Birth and Current Date (MS

Hi Macropod

I feel very infantile but I have virtually no computer skills when it comes
to anything more then simple word processing skills. I feel that this should
be easy and downloaded your tips and techniques but still find myself
struggling to recreate any of the things you describe. I need a simple two
or three column date formula. It would seem that you have an example almost
like what I am trying to create. I tried copying and pasting it (top of page
9) as a last resort and hoped to just modify to fit my needs. Butt..... for
one thing I can not seem to find anywhere click that says show book marks.
If you have the time to give me an example in word that I could insert in a
table to try out that would be absoulutely great!. I need a colum where I
can type in the date a client was referred to our program ( we like Feb. 3,
2005) type of thing then a column that calculates this first column from from
an automatically updating Today's date. So what I need is the numbers of
days a client is waiting for service on the date that we open that file. I
am sorry to bother you about this but it would make such a difference to our
work load and I feel that it is at the tip of my fingers to do this and I can
not seem to make it work.
Please help if you can.
Needs Direction

"macropod" wrote:

Hi Bill,

To see how to do this and just about everything else you might want to do
with dates in Word, check out my Date Calc 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=249902

Cheers


"Bill" wrote in message
...
Is this possible in a Word table?




  #4   Report Post  
Posted to microsoft.public.word.tables
macropod
 
Posts: n/a
Default Calculate Age in table from Date of Birth and Current Date (MS

Hi Bill,

Which fields are you referring to? On my system this first set of fields on
page 9 are headed 'Calculate the # Days Difference Between Two Dates'. Your
original post indicated you wanted to calculate someone's age, for which the
field headed 'Calculate A Person's Age' would seem more appropriate.

As for using the fields, the example under the heading 'Calculate the # Days
Difference Between Two Dates' takes it's input from two bookmarked fields,
named 'StartDate' and 'EndDate', respectively. As coded, that field isn't
interactive, but could fairly easily be made so by replacing the existing
'StartDate' and 'EndDate' cross-references in the with ASK fields to solicit
the 'StartDate' and 'EndDate' values. The ASK field that presently solicits
the 'StartDate' for this example is actually located in cell A1 in the table
under the heading 'Date Calculations in a Table'. The 'EndDate' value is
bookmarked on the same line as the formula field.

To use the field under the heading 'Calculate A Person's Age', simply select
it and press F9, as per the instructions at the front of the document. The
instructions also provide other useful information for viewing/working with
the field coding.

Getting these fields to work interactively in a table would require some
modification and would best be done using a Formfield in each cell requiring
input (you may only need to solicit the birthdate, since the date of the
calculation can be obtained from the system) and putting the table into a
section that is 'protected for forms'.

If you post back more details about the document & data you're working with
and what you're trying to achieve, it shouldn't be too difficult to find a
solution.

Finally, you might see where the bookmarks and fields are more easily if you
go to Tools|Options|View and:
.. check the 'bookmarks' box
.. set the 'Field shading' property to 'Always'.


Cheers


"Needs directcion" wrote in
message ...
Hi Macropod

I feel very infantile but I have virtually no computer skills when it

comes
to anything more then simple word processing skills. I feel that this

should
be easy and downloaded your tips and techniques but still find myself
struggling to recreate any of the things you describe. I need a simple

two
or three column date formula. It would seem that you have an example

almost
like what I am trying to create. I tried copying and pasting it (top of

page
9) as a last resort and hoped to just modify to fit my needs. Butt.....

for
one thing I can not seem to find anywhere click that says show book marks.
If you have the time to give me an example in word that I could insert in

a
table to try out that would be absoulutely great!. I need a colum where I
can type in the date a client was referred to our program ( we like Feb.

3,
2005) type of thing then a column that calculates this first column from

from
an automatically updating Today's date. So what I need is the numbers of
days a client is waiting for service on the date that we open that file.

I
am sorry to bother you about this but it would make such a difference to

our
work load and I feel that it is at the tip of my fingers to do this and I

can
not seem to make it work.
Please help if you can.
Needs Direction

"macropod" wrote:

Hi Bill,

To see how to do this and just about everything else you might want to

do
with dates in Word, check out my Date Calc 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=249902

Cheers


"Bill" wrote in message
...
Is this possible in a Word table?






  #5   Report Post  
Posted to microsoft.public.word.tables
Needs directcion
 
Posts: n/a
Default Calculate Age in table from Date of Birth and Current Date (MS

Hi Macropod
This is Needs Direction again. I do not know if I have sufficiently let you
know how inept I feel right now. Here is a copy of what I seem to be able to
achieve and it does not look like anything I hear you describing. I think I
may not have the right base table that you are referring to.
Totally defeated,
Needs Direction
PS Oh my goodness I cannot even tell how to attach a word document to this
post!
"macropod" wrote:

Hi Bill,

Which fields are you referring to? On my system this first set of fields on
page 9 are headed 'Calculate the # Days Difference Between Two Dates'. Your
original post indicated you wanted to calculate someone's age, for which the
field headed 'Calculate A Person's Age' would seem more appropriate.

As for using the fields, the example under the heading 'Calculate the # Days
Difference Between Two Dates' takes it's input from two bookmarked fields,
named 'StartDate' and 'EndDate', respectively. As coded, that field isn't
interactive, but could fairly easily be made so by replacing the existing
'StartDate' and 'EndDate' cross-references in the with ASK fields to solicit
the 'StartDate' and 'EndDate' values. The ASK field that presently solicits
the 'StartDate' for this example is actually located in cell A1 in the table
under the heading 'Date Calculations in a Table'. The 'EndDate' value is
bookmarked on the same line as the formula field.

To use the field under the heading 'Calculate A Person's Age', simply select
it and press F9, as per the instructions at the front of the document. The
instructions also provide other useful information for viewing/working with
the field coding.

Getting these fields to work interactively in a table would require some
modification and would best be done using a Formfield in each cell requiring
input (you may only need to solicit the birthdate, since the date of the
calculation can be obtained from the system) and putting the table into a
section that is 'protected for forms'.

If you post back more details about the document & data you're working with
and what you're trying to achieve, it shouldn't be too difficult to find a
solution.

Finally, you might see where the bookmarks and fields are more easily if you
go to Tools|Options|View and:
.. check the 'bookmarks' box
.. set the 'Field shading' property to 'Always'.


Cheers


"Needs directcion" wrote in
message ...
Hi Macropod

I feel very infantile but I have virtually no computer skills when it

comes
to anything more then simple word processing skills. I feel that this

should
be easy and downloaded your tips and techniques but still find myself
struggling to recreate any of the things you describe. I need a simple

two
or three column date formula. It would seem that you have an example

almost
like what I am trying to create. I tried copying and pasting it (top of

page
9) as a last resort and hoped to just modify to fit my needs. Butt.....

for
one thing I can not seem to find anywhere click that says show book marks.
If you have the time to give me an example in word that I could insert in

a
table to try out that would be absoulutely great!. I need a colum where I
can type in the date a client was referred to our program ( we like Feb.

3,
2005) type of thing then a column that calculates this first column from

from
an automatically updating Today's date. So what I need is the numbers of
days a client is waiting for service on the date that we open that file.

I
am sorry to bother you about this but it would make such a difference to

our
work load and I feel that it is at the tip of my fingers to do this and I

can
not seem to make it work.
Please help if you can.
Needs Direction

"macropod" wrote:

Hi Bill,

To see how to do this and just about everything else you might want to

do
with dates in Word, check out my Date Calc 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=249902

Cheers


"Bill" wrote in message
...
Is this possible in a Word table?








  #6   Report Post  
Posted to microsoft.public.word.tables
macropod
 
Posts: n/a
Default Calculate Age in table from Date of Birth and Current Date (MS

PS Oh my goodness I cannot even tell how to attach a word document to this
post!


You probably can't attach a file in this newsgroup, so you'll have to
explain it - or register and attach it in a reply to the thread starting
he
http://www.wopr.com/cgi-bin/w3t/show...?Number=432773

Cheers


  #7   Report Post  
Posted to microsoft.public.word.tables
Needs directcion
 
Posts: n/a
Default Calculate Age in table from Date of Birth and Current Date (MS

Thanks Macropod
I will try that.
Needs direction

"macropod" wrote:

PS Oh my goodness I cannot even tell how to attach a word document to this
post!


You probably can't attach a file in this newsgroup, so you'll have to
explain it - or register and attach it in a reply to the thread starting
he
http://www.wopr.com/cgi-bin/w3t/show...?Number=432773

Cheers



Reply
Thread Tools
Display Modes

Posting Rules

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

Forum Jump


All times are GMT +1. The time now is 12:10 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"