Automatically update year + 1

Charles Kenyon · #1 05-04-2020, 11:34 AM

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.

PrincessApril · #2 05-04-2020, 01:51 PM

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:

Code:

{QUOTE
{SET Delay 1}
{ Date \@ d/M/yyyy + 1 }

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.)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to search for a specific year from a table with year range?	Wii	Excel	0	05-05-2015 12:40 PM
How to calculate a rolling year-to-date percentage by quarter as the year progresses	sleake	Excel Programming	2	04-23-2015 11:51 AM
Networkdays per fiscal year in a 6 year range	jabnm	Excel	1	10-16-2014 11:51 AM
Year to Year in Fillable form	Lara	Word	1	04-09-2013 03:19 PM
Creative Ways for a year-to-year comparison???	ridonkulous5	Excel	1	03-23-2011 04:49 PM