[macropod[_2_]]

Far be it from me to suggest anything you post is 'annoyingly irrelevant' (;

--
Cheers
macropod
[MVP - Microsoft Word]


"Graham Mayor" wrote in message ...
At the time I prepared my message you hadn't posted .. so 'soon' then
applied
It's all to do with the speed the system is refreshed and it does sometimes
make individual replies seem a bit odd ... or annoyingly irrelevant

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



macropod wrote:
Hi Graham,

"No doubt Macropod will be along soon with his observations". Hmm,
'soon' has interesting connotations in this context - my initial
reply preceded yours!

"Graham Mayor" wrote in message
...
Macropod has covered TIME delays at the end of document you can
download from http://www.gmayor.com/downloads.htm#Third_party To add 12
hours to the Time associated with the SAVEDATE, substitute
SAVEDATE for the TIME field and change the delay to 12:00:00 thus:

{QUOTE
{SET Time1 {SAVEDATE \@ HH:mm:ss}}
{SET Time2 12:00:00}
{SET SumTime{=({Time1 \@ HH}+{Time2 \@ HH})*3600+({Time1 \@
mm}+{Time2 \@ mm})*60+{Time1 \@ ss}+{Time2 \@ ss}}}
{=INT(SumTime/86400) \# +0\ ;-0\ ;}
{=(MOD(ABS(INT(SumTime/3600)+11),12)+1)*10000+INT((SumTime-INT(SumTime/3600)*3600)/60)*100+MOD(SumTime,60)
\# 0:00:00} {IF{=MOD(INT(SumTime/3600),24)} 12 \ a.m. \ p.m.}} or (24
hour clock).


{QUOTE
{SET Time1 {SAVEDATE \@ HH:mm:ss}}
{SET Time2 12:00:00}
{SET SumTime{=({Time1 \@ HH}+{Time2 \@ HH})*3600+({Time1 \@
mm}+{Time2 \@ mm})*60+{Time1 \@ ss}+{Time2 \@ ss}}}
{=INT(SumTime/86400) \# +0\ ;-0\ ;}
{=(MOD(ABS(INT(SumTime/3600)+23),24)+1)*10000+INT((SumTime-INT(SumTime/3600)*3600)/60)*100+MOD(SumTime,60)
\# 00:00:00}} Note that savedate fields do not update automatically when
you save
the document. This can result in the form showing incorrect dates
and then if the fields are updated the form will require saving
again to record the new savedate, and thus the savedate saved with
the document is the previous savedate and not the current one. Are
you sure that Savedate is the best date type for your requirements?
Frankly if you save the form as a template and create form documents
from it Createdate would probably make more sense. No doubt Macropod
will be along soon with his observations

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Jenny B. wrote:
Hi Macropod,

I've read through your past postings on how to calculate between
dates for different periods of time (great work by the way).
However, most of the examples don't seem to focus on doing
calculations for just Time Difference vs. calculating Date Periods.
I'm trying to add time to the SAVEDATE time value. I still need the
SAVEDATE value to appear on my form, but I'm hoping to add another
field using that same logic as a springboard. I'd like to add 12
hours to the SAVEDATE time after the user saves the doc, but show
just the hour, minute, seconds and am/pm after calculation.

Do you have any other postings or documentation that provides
examples doing this vs. calculating the date periods?

Thank you for your review and thoughts - Jenny B.


EXAMPLE -- {=SAVEDATE \@ "M/d/yyy h:mmm:ss am/pm"} + 12 hours - -
GOAL - to have result appear as just H:MMM:SS AM/PM 12 hours later