Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Calculate Age in table from Date of Birth and Current Date (MSWord
Is this possible in a Word table?
|
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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 |