changing only year component in a date field using vba

[Zhibek]

Please can you help me to run macros which shows a constant date in the document property which must changing only year component in future.
for example today is 03/31/2018 after one year it must be 03/31/2019

Thank you in advance!

[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.

[Zhibek]

Thank you a lot!!

[Zhibek]

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~!

[macropod]

To see how to do this and just about everything else you might want to do with dates in Word, check out my Microsoft Word Date Calculation Tutorial, in the 'Sticky' thread at:
https://www.msofficeforums.com/word/...-tutorial.html
In particular, look at the item titled Calculate the day & date of the last or nth-to-last day of a given month. Do read the document's introductory material.

[Zhibek]

Originally Posted by macropod

To see how to do this and just about everything else you might want to do with dates in Word, check out my Microsoft Word Date Calculation Tutorial, in the 'Sticky' thread at:
https://www.msofficeforums.com/word/...-tutorial.html
In particular, look at the item titled Calculate the day & date of the last or nth-to-last day of a given month. Do read the document's introductory material.

Hi, Paul

It is GREAT. Thank you a lot!