B
Bill
Is this possible in a Word table?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
macropod
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/showthreaded.pl?Number=249902
Cheers
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/showthreaded.pl?Number=249902
Cheers
N
Needs directcion
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
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
M
macropod
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
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
N
Needs directcion
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!
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!
M
macropod
PS Oh my goodness I cannot even tell how to attach a word document to this
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
here:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=432773
Cheers
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
here:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=432773
Cheers
N
Needs directcion
Thanks Macropod
I will try that.
Needs direction
I will try that.
Needs direction
macropod said: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
here:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=432773
Cheers
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.