DISPLAYING THE DAYS SINCE AN EVENT
in [Word VBA]
|
Prev: Page number fields issue
Next: email document
From: calsax on 1 Jul 2008 01:17 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!
From: Doug Robbins - Word MVP on 1 Jul 2008 02:24 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(a)discussions.microsoft.com> wrote in message news:7457552F-DD40-4AB3-BAEE-DDAE920A7378(a)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!
From: macropod on 1 Jul 2008 03:48 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(a)discussions.microsoft.com> wrote in message news:7457552F-DD40-4AB3-BAEE-DDAE920A7378(a)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!
From: calsax on 1 Jul 2008 11:40 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(a)discussions.microsoft.com> wrote in message > news:7457552F-DD40-4AB3-BAEE-DDAE920A7378(a)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! > > >
From: calsax on 1 Jul 2008 11:42
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(a)discussions.microsoft.com> wrote in message news:7457552F-DD40-4AB3-BAEE-DDAE920A7378(a)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! > > |