Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-04-2020, 04:39 PM
Charles Kenyon Charles Kenyon is offline Automatically update year + 1 Windows 10 Automatically update year + 1 Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,584
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

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.
Reply With Quote
  #2  
Old 05-04-2020, 04:57 PM
macropod's Avatar
macropod macropod is offline Automatically update year + 1 Windows 7 64bit Automatically update year + 1 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Charles Kenyon View Post
Try instead:
{QUOTE {SET Delay 1} {DATE \@ "d/MMMM/"}{={DATE \@ yyyy}+Delay}}
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]
Reply With Quote
Reply

Tags
future date, year

Thread Tools
Display Modes


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
Automatically update year + 1 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:06 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft