changing only year component in a date field using vba

gmayor · #1 08-08-2018, 10:57 PM

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.

Zhibek · #2 08-08-2018, 11:43 PM

Thank you a lot!!

Zhibek · #3 08-16-2018, 12:03 AM

Quote:

Originally Posted by gmayor

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, hi!
3/31/{ DATE \@ "yyyy" }
here what should I add if I need always show the last day of March in the next year?
For example:
today is 16/8/2018
in document it must shows 3/31/2019

Thank you for help~!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
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 date format in Bibliography field	elly111sk	Word	3	07-25-2012 06:54 PM