View Single Post
 
Old 07-24-2019, 03:59 PM
eduzs eduzs is offline Windows 10 Office 2010 32bit
Expert
 
Join Date: May 2017
Posts: 266
eduzs is on a distinguished road
Default Word field last month not working within year change

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.
__________________
Backup your original file before doing any modification.
Reply With Quote