Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 08-08-2018, 10:57 PM
gmayor's Avatar
gmayor gmayor is offline changing only year component in a date field using vba Windows 10 changing only year component in a date field using vba 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
changing only year component in a date field using vba Trying to generate a Documents with the date for every day of the year. RLAlura Mail Merge 2 01-28-2016 02:57 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
changing only year component in a date field using vba How to insert a year-only SaveDate field David Ziegler Word 2 04-10-2014 07:38 PM
Date field inserting merge date in blank field Lesley Mail Merge 5 09-30-2013 01:49 AM
changing only year component in a date field using vba changing date format in Bibliography field elly111sk Word 3 07-25-2012 06:54 PM

Other Forums: Access Forums

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