Word field last month not working within year change

eduzs · #1 07-24-2019, 03:59 PM

Hi there!
The goal is to list the last 12 months.
I have this fields codes which are working fine within the current year:

Code:

.
.
.
{QUOTE “01- { ={MOD({Date \@ MM} +10;12)-2 }” \@ MMM/yyyy} 
{QUOTE “01- { ={MOD({Date \@ MM} +10;12)-1 }” \@ MMM/yyyy}
 {QUOTE “01- { ={MOD({Date \@ MM} +10;12) }” \@ MMM/yyyy}
 {QUOTE “01- { ={MOD({Date \@ MM} +10;12)+1 }” \@ MMM/yyyy}

The problem is when the year changes, so when expected "Dec/2018" I got "01-0,0".
Ps.: My region date format "DD-MM-YYYY", list separator ";".
Any Ideas?
Thanks in advance.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Empty date cell shows wrong month & year	Learner7	Excel	3	06-16-2019 11:09 AM
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