DISPLAYING THE DAYS SINCE AN EVENT

I need to be able to display the number of days since an event. I would like
to have the document creator input a date, then have a display that shows the
number of days since that date at print. Any suggestions?

Thanks!

Doug
Mon Jun 30 23:24:41 PDT 2008

Use the DateDiff() function.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"calsax" <calsax@discussions.microsoft.com> wrote in message
news:7457552F-DD40-4AB3-BAEE-DDAE920A7378@microsoft.com...
>I need to be able to display the number of days since an event. I would
>like
> to have the document creator input a date, then have a display that shows
> the
> number of days since that date at print. Any suggestions?
>
> Thanks!

macropod
Tue Jul 01 00:48:43 PDT 2008

Hi calsax,

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
or
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the item titled 'Calculate the # Days Difference Between Two Dates'. With that example, you could substitute
a formfield or a userform to set the 'StartDate' bookmark's value. Alternatively, you could embed and ASK field in the calculation
field, as per some of the other examples in that document.

Cheers


"calsax" <calsax@discussions.microsoft.com> wrote in message news:7457552F-DD40-4AB3-BAEE-DDAE920A7378@microsoft.com...
>I need to be able to display the number of days since an event. I would like
> to have the document creator input a date, then have a display that shows the
> number of days since that date at print. Any suggestions?
>
> Thanks!

calsax
Tue Jul 01 08:40:03 PDT 2008

Thank you for the reply. I will try to make this work!

"Doug Robbins - Word MVP" wrote:

> Use the DateDiff() function.
>
> --
> Hope this helps.
>
> Please reply to the newsgroup unless you wish to avail yourself of my
> services on a paid consulting basis.
>
> Doug Robbins - Word MVP
>
> "calsax" <calsax@discussions.microsoft.com> wrote in message
> news:7457552F-DD40-4AB3-BAEE-DDAE920A7378@microsoft.com...
> >I need to be able to display the number of days since an event. I would
> >like
> > to have the document creator input a date, then have a display that shows
> > the
> > number of days since that date at print. Any suggestions?
> >
> > Thanks!
>
>
>

calsax
Tue Jul 01 08:42:02 PDT 2008

Thank you! It looks like you gave me what I need. I am far more comfortable
in Access or Excel than Word, but when the boss says "can this be done" and
you naively say "sure", you just have to move forward.

Thanks!!!!!!!

"macropod" wrote:

> Hi calsax,
>
> 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
> or
> http://www.gmayor.com/downloads.htm#Third_party
> In particular, look at the item titled 'Calculate the # Days Difference Between Two Dates'. With that example, you could substitute
> a formfield or a userform to set the 'StartDate' bookmark's value. Alternatively, you could embed and ASK field in the calculation
> field, as per some of the other examples in that document.
>
> Cheers
>
>
> "calsax" <calsax@discussions.microsoft.com> wrote in message news:7457552F-DD40-4AB3-BAEE-DDAE920A7378@microsoft.com...
> >I need to be able to display the number of days since an event. I would like
> > to have the document creator input a date, then have a display that shows the
> > number of days since that date at print. Any suggestions?
> >
> > Thanks!
>
>

calsax
Wed Jul 02 10:41:02 PDT 2008

The code in your "Tips & Techniques" works great! I used the "Days
Difference" code with an Ask for the start date. Now for one more question:

How can I have the document automagically update the displayed values in the
fields at print time (or when the doc is opened) to reflect to current values?

Thanks again for all your help!!!!

calsax

"macropod" wrote:

> Hi calsax,
>
> 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
> or
> http://www.gmayor.com/downloads.htm#Third_party
> In particular, look at the item titled 'Calculate the # Days Difference Between Two Dates'. With that example, you could substitute
> a formfield or a userform to set the 'StartDate' bookmark's value. Alternatively, you could embed and ASK field in the calculation
> field, as per some of the other examples in that document.
>
> Cheers
>
>
> "calsax" <calsax@discussions.microsoft.com> wrote in message news:7457552F-DD40-4AB3-BAEE-DDAE920A7378@microsoft.com...
> >I need to be able to display the number of days since an event. I would like
> > to have the document creator input a date, then have a display that shows the
> > number of days since that date at print. Any suggestions?
> >
> > Thanks!
>
>

CompassRose
Wed Jul 02 14:25:04 PDT 2008

Calsax

If you go to Tools -> Options... -> Print tab, check the 'Update fields'
box, and your
ASK fields will prompt the user for input before each time the document is
printed. If the user has previously put data into ASK box, the data will
appear in the box and all they have to do is click OK or change the data if
they wish.

David

"calsax" wrote:

> The code in your "Tips & Techniques" works great! I used the "Days
> Difference" code with an Ask for the start date. Now for one more question:
>
> How can I have the document automagically update the displayed values in the
> fields at print time (or when the doc is opened) to reflect to current values?
>
> Thanks again for all your help!!!!
>
> calsax
>
> "macropod" wrote:
>
> > Hi calsax,
> >
> > 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
> > or
> > http://www.gmayor.com/downloads.htm#Third_party
> > In particular, look at the item titled 'Calculate the # Days Difference Between Two Dates'. With that example, you could substitute
> > a formfield or a userform to set the 'StartDate' bookmark's value. Alternatively, you could embed and ASK field in the calculation
> > field, as per some of the other examples in that document.
> >
> > Cheers
> >
> >
> > "calsax" <calsax@discussions.microsoft.com> wrote in message news:7457552F-DD40-4AB3-BAEE-DDAE920A7378@microsoft.com...
> > >I need to be able to display the number of days since an event. I would like
> > > to have the document creator input a date, then have a display that shows the
> > > number of days since that date at print. Any suggestions?
> > >
> > > Thanks!
> >
> >

calsax
Wed Jul 02 17:21:01 PDT 2008

Thank you!!!!!

I guess I am going to have to start studying Word more...

"Compass Rose" wrote:

> Calsax
>
> If you go to Tools -> Options... -> Print tab, check the 'Update fields'
> box, and your
> ASK fields will prompt the user for input before each time the document is
> printed. If the user has previously put data into ASK box, the data will
> appear in the box and all they have to do is click OK or change the data if
> they wish.
>
> David
>
> "calsax" wrote:
>
> > The code in your "Tips & Techniques" works great! I used the "Days
> > Difference" code with an Ask for the start date. Now for one more question:
> >
> > How can I have the document automagically update the displayed values in the
> > fields at print time (or when the doc is opened) to reflect to current values?
> >
> > Thanks again for all your help!!!!
> >
> > calsax
> >
> > "macropod" wrote:
> >
> > > Hi calsax,
> > >
> > > 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
> > > or
> > > http://www.gmayor.com/downloads.htm#Third_party
> > > In particular, look at the item titled 'Calculate the # Days Difference Between Two Dates'. With that example, you could substitute
> > > a formfield or a userform to set the 'StartDate' bookmark's value. Alternatively, you could embed and ASK field in the calculation
> > > field, as per some of the other examples in that document.
> > >
> > > Cheers
> > >
> > >
> > > "calsax" <calsax@discussions.microsoft.com> wrote in message news:7457552F-DD40-4AB3-BAEE-DDAE920A7378@microsoft.com...
> > > >I need to be able to display the number of days since an event. I would like
> > > > to have the document creator input a date, then have a display that shows the
> > > > number of days since that date at print. Any suggestions?
> > > >
> > > > Thanks!
> > >
> > >

macropod
Wed Jul 02 17:41:15 PDT 2008

Hi Calsax,

BTW, although you've posted in a vba newsgroup, the solution I directed you to is not vba - it uses Word fields instead. As a
result, it doesn't raise any of the security issues you might get with vba.

Cheers


"calsax" <calsax@discussions.microsoft.com> wrote in message news:1AC5D15A-BBBA-4603-B470-7F925CCEB320@microsoft.com...
> Thank you!!!!!
>
> I guess I am going to have to start studying Word more...
>
> "Compass Rose" wrote:
>
>> Calsax
>>
>> If you go to Tools -> Options... -> Print tab, check the 'Update fields'
>> box, and your
>> ASK fields will prompt the user for input before each time the document is
>> printed. If the user has previously put data into ASK box, the data will
>> appear in the box and all they have to do is click OK or change the data if
>> they wish.
>>
>> David
>>
>> "calsax" wrote:
>>
>> > The code in your "Tips & Techniques" works great! I used the "Days
>> > Difference" code with an Ask for the start date. Now for one more question:
>> >
>> > How can I have the document automagically update the displayed values in the
>> > fields at print time (or when the doc is opened) to reflect to current values?
>> >
>> > Thanks again for all your help!!!!
>> >
>> > calsax
>> >
>> > "macropod" wrote:
>> >
>> > > Hi calsax,
>> > >
>> > > 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
>> > > or
>> > > http://www.gmayor.com/downloads.htm#Third_party
>> > > In particular, look at the item titled 'Calculate the # Days Difference Between Two Dates'. With that example, you could
>> > > substitute
>> > > a formfield or a userform to set the 'StartDate' bookmark's value. Alternatively, you could embed and ASK field in the
>> > > calculation
>> > > field, as per some of the other examples in that document.
>> > >
>> > > Cheers
>> > >
>> > >
>> > > "calsax" <calsax@discussions.microsoft.com> wrote in message news:7457552F-DD40-4AB3-BAEE-DDAE920A7378@microsoft.com...
>> > > >I need to be able to display the number of days since an event. I would like
>> > > > to have the document creator input a date, then have a display that shows the
>> > > > number of days since that date at print. Any suggestions?
>> > > >
>> > > > Thanks!
>> > >
>> > >