Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Trying to create an auto field that gives todays date +28 days?
Hey all,
I use Word97. I'm trying to create an auto update field that shows the print date + 28 days in 'day, date month year' format in a letter. The field code for the print date is: { PRINTDATE \@ "dddd, dd MMMM yyyy" \* MERGEFORMAT } I've experimented with a couple of things, but had no glory at all. Cheers Tony |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Trying to create an auto field that gives todays date +28 days?
Unfortunately, Word doesn't provide a simple field-based way to do date
arithmetic. If you've got nothing better to do and yoru document has no legal significance, you can experiment Macropod's hilarious field calculations (do a Google); but if the requirement is anything serious, you'll need to use a macro. "Ranger Tony" Ranger wrote in message ... Hey all, I use Word97. I'm trying to create an auto update field that shows the print date + 28 days in 'day, date month year' format in a letter. The field code for the print date is: { PRINTDATE \@ "dddd, dd MMMM yyyy" \* MERGEFORMAT } I've experimented with a couple of things, but had no glory at all. Cheers Tony |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Trying to create an auto field that gives todays date +28 days?
How do you think a date inserted by macro or even typed from the keyboard
would have greater legal significance than one inserted by a field calculation? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jezebel wrote: Unfortunately, Word doesn't provide a simple field-based way to do date arithmetic. If you've got nothing better to do and yoru document has no legal significance, you can experiment Macropod's hilarious field calculations (do a Google); but if the requirement is anything serious, you'll need to use a macro. "Ranger Tony" Ranger wrote in message ... Hey all, I use Word97. I'm trying to create an auto update field that shows the print date + 28 days in 'day, date month year' format in a letter. The field code for the print date is: { PRINTDATE \@ "dddd, dd MMMM yyyy" \* MERGEFORMAT } I've experimented with a couple of things, but had no glory at all. Cheers Tony |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Trying to create an auto field that gives todays date +28 days?
I think it would be irresponsible, in a formal application, to rely on a
field calculation of the Macropod sort. Those field sequences (converting to Julian number and back) are technically -- ie, in the audit sense -- 'complex calculations' of the sort that requires, in any situation subject to audit, formally documented validation. These is easily provided for macro code -- particularly for code as trivial as adding 28 to a date; it is not easily provided for a nested field calculation that runs to more than 300 characters and five levels of nesting. "Graham Mayor" wrote in message ... How do you think a date inserted by macro or even typed from the keyboard would have greater legal significance than one inserted by a field calculation? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jezebel wrote: Unfortunately, Word doesn't provide a simple field-based way to do date arithmetic. If you've got nothing better to do and yoru document has no legal significance, you can experiment Macropod's hilarious field calculations (do a Google); but if the requirement is anything serious, you'll need to use a macro. "Ranger Tony" Ranger wrote in message ... Hey all, I use Word97. I'm trying to create an auto update field that shows the print date + 28 days in 'day, date month year' format in a letter. The field code for the print date is: { PRINTDATE \@ "dddd, dd MMMM yyyy" \* MERGEFORMAT } I've experimented with a couple of things, but had no glory at all. Cheers Tony |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Trying to create an auto field that gives todays date +28 days?
I have no argument that macro's are simpler (maybe not so simple in a mail
merge) - but you brought up 'legal significance' and there is none. The field constructions may be complex, but they work (and in the final analysis that is all that matters), and all the donkey work has already been done. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jezebel wrote: I think it would be irresponsible, in a formal application, to rely on a field calculation of the Macropod sort. Those field sequences (converting to Julian number and back) are technically -- ie, in the audit sense -- 'complex calculations' of the sort that requires, in any situation subject to audit, formally documented validation. These is easily provided for macro code -- particularly for code as trivial as adding 28 to a date; it is not easily provided for a nested field calculation that runs to more than 300 characters and five levels of nesting. "Graham Mayor" wrote in message ... How do you think a date inserted by macro or even typed from the keyboard would have greater legal significance than one inserted by a field calculation? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jezebel wrote: Unfortunately, Word doesn't provide a simple field-based way to do date arithmetic. If you've got nothing better to do and yoru document has no legal significance, you can experiment Macropod's hilarious field calculations (do a Google); but if the requirement is anything serious, you'll need to use a macro. "Ranger Tony" Ranger wrote in message ... Hey all, I use Word97. I'm trying to create an auto update field that shows the print date + 28 days in 'day, date month year' format in a letter. The field code for the print date is: { PRINTDATE \@ "dddd, dd MMMM yyyy" \* MERGEFORMAT } I've experimented with a couple of things, but had no glory at all. Cheers Tony |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Trying to create an auto field that gives todays date +28 days?
The assertion that those field calculations "work" is questionable. They
certainly work *sometimes* -- but it's not easy to prove it -- which an auditor is entitled to ask you to do. Clearly some correspondence has legal significance -- particularly letters with statements like "do such-and-such within 28 days of the date of this letter". As a matter of practical corporate goverance, obviously you can't check every single calculation in every single document. What you can do -- and if you're an entity subject to Sarbanes-Oxley, MUST do -- is require that such calculations meet some standard of verifiability. The requirements of Sarbanes-Oxley (and the equivalents outside the US) are pretty specific, and methods like Macropod's fields simply don't meet them. It's more often a problem with spreadsheets than with documents, but the principle is the same. "Graham Mayor" wrote in message ... I have no argument that macro's are simpler (maybe not so simple in a mail merge) - but you brought up 'legal significance' and there is none. The field constructions may be complex, but they work (and in the final analysis that is all that matters), and all the donkey work has already been done. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jezebel wrote: I think it would be irresponsible, in a formal application, to rely on a field calculation of the Macropod sort. Those field sequences (converting to Julian number and back) are technically -- ie, in the audit sense -- 'complex calculations' of the sort that requires, in any situation subject to audit, formally documented validation. These is easily provided for macro code -- particularly for code as trivial as adding 28 to a date; it is not easily provided for a nested field calculation that runs to more than 300 characters and five levels of nesting. "Graham Mayor" wrote in message ... How do you think a date inserted by macro or even typed from the keyboard would have greater legal significance than one inserted by a field calculation? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jezebel wrote: Unfortunately, Word doesn't provide a simple field-based way to do date arithmetic. If you've got nothing better to do and yoru document has no legal significance, you can experiment Macropod's hilarious field calculations (do a Google); but if the requirement is anything serious, you'll need to use a macro. "Ranger Tony" Ranger wrote in message ... Hey all, I use Word97. I'm trying to create an auto update field that shows the print date + 28 days in 'day, date month year' format in a letter. The field code for the print date is: { PRINTDATE \@ "dddd, dd MMMM yyyy" \* MERGEFORMAT } I've experimented with a couple of things, but had no glory at all. Cheers Tony |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Trying to create an auto field that gives todays date +28 days?
See http://www.gmayor.com/insert_a_date_...than_today.htm .
Ranger Tony wrote: Hey all, I use Word97. I'm trying to create an auto update field that shows the print date + 28 days in 'day, date month year' format in a letter. The field code for the print date is: { PRINTDATE \@ "dddd, dd MMMM yyyy" \* MERGEFORMAT } I've experimented with a couple of things, but had no glory at all. Cheers Tony |
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Trying to create an auto field that gives todays date +28 days?
Hi Tony,
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 PS: You can safely ignore Jezebel's rantings on this. "Ranger Tony" Ranger wrote in message ... Hey all, I use Word97. I'm trying to create an auto update field that shows the print date + 28 days in 'day, date month year' format in a letter. The field code for the print date is: { PRINTDATE \@ "dddd, dd MMMM yyyy" \* MERGEFORMAT } I've experimented with a couple of things, but had no glory at all. Cheers Tony |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic date change | Microsoft Word Help | |||
How do I create a input text field and a input date field? | Page Layout | |||
Convert Date Field to Text | Microsoft Word Help | |||
Auto date is incorrect -- date in settings is correct | Microsoft Word Help | |||
Date Field in Merge Document | Mailmerge |