Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-29-2017, 03:55 AM
corriganc corriganc is offline Want to use the DateAdd function to type text at a location in word document, using date from CC Windows 10 Want to use the DateAdd function to type text at a location in word document, using date from CC Office 2016
Novice
Want to use the DateAdd function to type text at a location in word document, using date from CC
 
Join Date: Jul 2017
Location: United Kingdom
Posts: 6
corriganc is on a distinguished road
Smile Genius!



Quote:
Originally Posted by gmayor View Post
There is no code in your documents as docx format does not support code.

You can use the content control exit event to perform calculations, something like the attached, but you need to name at least the relevant fields (and better still all of them) and you need to have a date value that you can add to. Your Date of Manufacture field shows only the year. You cannot add months to a year. So in the attached I have added a last examination field for the purpose of demonstration.

The code adds six months of a year to the value of that date (or nothing if the field is showing the prompt).
You are a genius!
I have no idea how you managed to do this, and I am very grateful. Could you just do me one more huge favour please?

Where you added the "Last Examination" line into the document, in order for it to calculate the "Next Examination" value, it actually needs to come from the date field which is in the black textbox at the bottom of the page.

I have included an image with this reply so that it makes more sense. If you could look into this for me please, I would be most grateful - I am going to try to work it out by myself in the meantime, but I fear that I will be just as useless this time as the first time!

Thankyou in advance, and for what you have done already.

Callum
Attached Images
File Type: jpg Template-Ammends.JPG (73.1 KB, 24 views)
Attached Files
File Type: docm template-fixed-upload.docm (39.5 KB, 11 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Want to use the DateAdd function to type text at a location in word document, using date from CC How to have the location (path) of the Word document on the title bar? Jamal NUMAN Word 24 09-06-2017 12:18 PM
Returning text, date, time, location from one Excel sheet to another dave57 Excel 17 06-15-2017 10:45 AM
Want to use the DateAdd function to type text at a location in word document, using date from CC Word type document auto fill in Sircooks Excel 5 05-14-2016 05:01 AM
Want to use the DateAdd function to type text at a location in word document, using date from CC Why do pages 10-24 disappear when I type in more text on page 2 or paste new text into the document? RET Word 1 05-02-2016 07:28 PM
Date Function in word? aligahk06 Word 1 04-21-2010 06:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:22 AM.


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