Thread: changing only year component in a date field using vba
View Single Post
 
Old 08-08-2018, 10:57 PM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
  
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
Which 'document property' did you have in mind?
Your message subject says 'date field'. If you want to insert a date field, you don't need a macro you simply insert a date field with a formatting switch to dsiplay only the year e.g. { DATE \@ "yyyy" } - use CTRL+F9 for the field brackets. The rest is just text thus
3/31/{ DATE \@ "yyyy" }
will always show the last day of March in the current year.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote