Hi all,

I have been attempting to use the calculated date tutorial for the first time. I have a date displayed in the Word doc by default and need it to default to today's date + 1 year.

In the tutorial, I see:

When I insert this into the Field Code after hitting Alt+F9, the date still reads as today's date. I don't quite see what I'd change given that the delay+1 seems set>



(I realize I could have played with this more, and I do normally enjoy solving things myself, but I'm a medical social worker serving individuals who are immunocompromised and hoping someone won't mind giving me a one-time pass in helping with a solution here to save some time given the pandemic. Thank you so much for your understanding and assistance.)

What I get with this code is May 2021. Are you getting May 2020?

Did you press F9 with the entire code selected after inserting it?


Did you read the introductory material in the tutorial? It is important.

The following gives me May 4, 2021.
{ Date \@ "MMMM d" }, { = { DATE \@ yyyy } + 1 }


I do not understand the 160 in Paul's but am guessing it has to do with a 360 day accounting year.
In general the math for a year is much simpler than for month and day.



Paul is a regular here and will likely explain all.

Hi there,

I copy and paste the source code from Paul's doc, after hitting Alt+F9 to toggle the field codes on. I see that Ctrl + F9 would allow me to introduce a field as well, but I think pasting the source code in while field codes are toggled on should work? The output I get is March 38536, which I don't understand, except that maybe it's one of the other calendars mentioned in the intro.

I'd like the output to be 4/5/2021 (1 year from today's date), so I tried changing the date configuration as follows:

But the output now in my document is just blank.

(p.s. The 160 in Paul's original inserts a nonbreaking space, according to the instructions.)

Alt+F9 doesn't refresh the field; it simply toggles the field code display on/off. Select the field and press F9.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

The code you started with has no day code.
{QUOTE {SET Delay 1} {DATE \@ MMMM}160{={DATE \@ yyyy}+Delay}}

Try instead:
{QUOTE {SET Delay 1} {DATE \@ "d/MMMM/"}{={DATE \@ yyyy}+Delay}}

Since you are editing the DATE field, when you toggle it back to results, those results are not changed until the field is updated. That is why both of us have told you that you need to press the F9 key to update the field.

Yes, Ctrl+F9 lets you insert a blank field to type in.

That simply won't work for leap years (i.e. Feb 29). The tutorial has field coding to address the leap year issue.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Paul, you are correct.
He started with the wrong formula from DateCalc.
He was using the one for Month and Year but wanted to include the day. That is also found in your work.


Here it is formatted the way he wants it:
Today, it returns 5/4/2021
This is formatted for US not European date format.
Here is a document containing the field.

Attached Files

DateOneYearLater.docx (48.6 KB, 15 views)

Thank you Paul and Charles. I really appreciate the assistance.

I'll have to go through the tutorial more closely, because even when I paste in the final code below, select it, and hit F9, I was still doing something wrong (or not doing something right!) because I believe the output was blank.

In any case, you helped me get a form together quickly that will help our clients, which is quite helpful during this time. Thank you again.

Without actually seeing your implementation in a document, it can be difficult for anyone to diagnose the issue. Can you attach a document to a post with your implementation of the field (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Did you try the sample I posted? Try pasting that into your document.
Then do take the time to review the introductory material in the tutorial.

Among other things, the fields in it are sensitive to your regional date settings.