Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-18-2016, 01:32 AM
CepheiMD CepheiMD is offline Insert a field Windows 7 64bit Insert a field Office 2010 64bit
Novice
Insert a field
 
Join Date: Mar 2016
Posts: 3
CepheiMD is on a distinguished road
Default Insert a field

Help me please with the following.



I want to insert a field based on a bookmark which would display a value from a table in the same document (see the example below).

For example: In a table I created a bookmark = Date1 - this field will contain date and time values with the format 29.02.16 15:22:58 (dd.MM.yy HH:mm:ss).

I want to return in the other part of the document the value 29.02.2016 (dd.MM.yyyy).

I created a field and in formula bar inserted =Date1, but it returns the entire value "29.02.16 15:22:58".

How to modify the format of the displayed value? I tried =Date1\@ "dd.MM.yyyy" but received error.
Reply With Quote
  #2  
Old 03-18-2016, 01:47 AM
Charles Kenyon Charles Kenyon is offline Insert a field Windows 8 Insert a field Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,471
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

{ Ref Date1 \@ "dd.MM.yyyy"}
Reply With Quote
  #3  
Old 03-18-2016, 01:56 AM
CepheiMD CepheiMD is offline Insert a field Windows 7 64bit Insert a field Office 2010 64bit
Novice
Insert a field
 
Join Date: Mar 2016
Posts: 3
CepheiMD is on a distinguished road
Default

Works great. Thanks!
Reply With Quote
Reply

Tags
bookmarks reference field, form, format

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert a field Insert text form field help sj80 Word 1 01-26-2016 10:50 PM
Insert a field IF... THEN... ELSE... rule to insert a Mailmerge Field SoonerLater Mail Merge 3 09-13-2015 03:52 PM
Insert a field How to insert a year-only SaveDate field David Ziegler Word 2 04-10-2014 07:38 PM
Insert a field insert database as field david_89_ Mail Merge 3 03-26-2014 06:02 AM
Insert a field VBA to insert field references SaneMan Word VBA 2 11-01-2013 02:38 AM

Other Forums: Access Forums

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