Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-25-2019, 04:31 PM
eduzs eduzs is offline Word field last month not working within year change Windows 10 Word field last month not working within year change Office 2010 32bit
Expert
Word field last month not working within year change
 
Join Date: May 2017
Posts: 266
eduzs is on a distinguished road
Default

Works like a charm! Thanks gmayor!
I just needed to change the list separator and the delay to get last 12 months (0, -1, -2, -3...).


Quote:
Originally Posted by gmayor View Post
Assuming UK/Australia pattern date format is used where you live the following will give you the last 12 months from today (page 6 of Paul's document). If you use US format dates then see the preface of Paul's document for the conversion. If you want the last 12 months add a minus sign before the delay values e.g..

{QUOTE{SET Delay -1}{SET m{=MOD({DATE \@ MM}+Delay+11,12)+1}}{SET y{=INT({DATE \@ yyyy}+(Delay+{DATE \@ M}-1)/12)}}"{m}-{y}" \@ "MMMM yyyy"}
{QUOTE{SET Delay -2}{SET m{=MOD({DATE \@ MM}+Delay+11,12)+1}}{SET y{=INT({DATE \@ yyyy}+(Delay+{DATE \@ M}-1)/12)}}"{m}-{y}" \@ "MMMM yyyy"}
{QUOTE{SET Delay -3}{SET m{=MOD({DATE \@ MM}+Delay+11,12)+1}}{SET y{=INT({DATE \@ yyyy}+(Delay+{DATE \@ M}-1)/12)}}"{m}-{y}" \@ "MMMM yyyy"}
{QUOTE{SET Delay -4}{SET m{=MOD({DATE \@ MM}+Delay+11,12)+1}}{SET y{=INT({DATE \@ yyyy}+(Delay+{DATE \@ M}-1)/12)}}"{m}-{y}" \@ "MMMM yyyy"}
{QUOTE{SET Delay -5}{SET m{=MOD({DATE \@ MM}+Delay+11,12)+1}}{SET y{=INT({DATE \@ yyyy}+(Delay+{DATE \@ M}-1)/12)}}"{m}-{y}" \@ "MMMM yyyy"}
{QUOTE{SET Delay -6}{SET m{=MOD({DATE \@ MM}+Delay+11,12)+1}}{SET y{=INT({DATE \@ yyyy}+(Delay+{DATE \@ M}-1)/12)}}"{m}-{y}" \@ "MMMM yyyy"}
{QUOTE{SET Delay -7}{SET m{=MOD({DATE \@ MM}+Delay+11,12)+1}}{SET y{=INT({DATE \@ yyyy}+(Delay+{DATE \@ M}-1)/12)}}"{m}-{y}" \@ "MMMM yyyy"}
{QUOTE{SET Delay -8}{SET m{=MOD({DATE \@ MM}+Delay+11,12)+1}}{SET y{=INT({DATE \@ yyyy}+(Delay+{DATE \@ M}-1)/12)}}"{m}-{y}" \@ "MMMM yyyy"}
{QUOTE{SET Delay -9}{SET m{=MOD({DATE \@ MM}+Delay+11,12)+1}}{SET y{=INT({DATE \@ yyyy}+(Delay+{DATE \@ M}-1)/12)}}"{m}-{y}" \@ "MMMM yyyy"}
{QUOTE{SET Delay -10}{SET m{=MOD({DATE \@ MM}+Delay+11,12)+1}}{SET y{=INT({DATE \@ yyyy}+(Delay+{DATE \@ M}-1)/12)}}"{m}-{y}" \@ "MMMM yyyy"}
{QUOTE{SET Delay -11}{SET m{=MOD({DATE \@ MM}+Delay+11,12)+1}}{SET y{=INT({DATE \@ yyyy}+(Delay+{DATE \@ M}-1)/12)}}"{m}-{y}" \@ "MMMM yyyy"}
{QUOTE{SET Delay -12}{SET m{=MOD({DATE \@ MM}+Delay+11,12)+1}}{SET y{=INT({DATE \@ yyyy}+(Delay+{DATE \@ M}-1)/12)}}"{m}-{y}" \@ "MMMM yyyy"}

which produces

June 2019
May 2019
April 2019
March 2019
February 2019
January 2019
December 2018
November 2018
October 2018


September 2018
August 2018
July 2018

Copy the field code sequence from Paul's document or use Import and export field constructions as text to restore the fields.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word field last month not working within year change Empty date cell shows wrong month & year Learner7 Excel 3 06-16-2019 11:09 AM
Word field last month not working within year change can i make a dropdown style calender to select the month and year to enter vacation time taken jamesbriese Excel 1 12-06-2016 01:00 PM
Excel day date month year Function greginky Excel 1 01-05-2016 02:19 AM
Macro now fails in Word 2013 after working for more than a year; still works in 2007 cyraxote Word VBA 10 09-05-2015 12:33 AM
Formula to count entries as per month, year and submission wise from different sheets pinkacidpunk Excel 1 05-28-2013 08:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:49 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