Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-08-2018, 09:51 AM
MimiCush MimiCush is offline use different date format in a reference Windows 10 use different date format in a reference Office 2013
Novice
use different date format in a reference
 
Join Date: Jan 2018
Posts: 29
MimiCush is on a distinguished road
Default use different date format in a reference

I just started using bookmarks to enter fields and references to copy the fields. (I know, I should have been doing this for a long time.) Anyway, I have been using "charformat" which works great. However, I have a challenge for all of you SuperUsers.



I would like to enter a date (say with a format of mmmm dd, yyyy) and bookmark it. But then I would like to reference the bookmark but format it differently, not just the char format, but the date format (such as mm-dd-yy). I have not been able to find a way to do it.

Any suggestions?
Reply With Quote
  #2  
Old 01-08-2018, 03:14 PM
macropod's Avatar
macropod macropod is offline use different date format in a reference Windows 7 64bit use different date format in a reference Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Unless you're after minutes, the date switch for the first field should be:
\@ "MMMM DD, YYYY"
not:
\@ "mmmm dd, yyyy"

As for the cross-reference, that's a simple matter of using a different date switch there:
\@ "MM-DD-YY"

Note: If you're using the \* Charformat switch along with a date switch, the \* Charformat must be inserted after the date switch.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-09-2018, 08:19 AM
MimiCush MimiCush is offline use different date format in a reference Windows 10 use different date format in a reference Office 2013
Novice
use different date format in a reference
 
Join Date: Jan 2018
Posts: 29
MimiCush is on a distinguished road
Default

Paul,

I am not sure I get this. Should I use a switch in my bookmark? I have not been able to do that.


I entered this exactly -

February 13, 2018

as my bookmark named AdoptDate

then as my crossref

{ ref AdoptDate \@ mm-dd-yyyy ]

It showed -

00-13-2018
Reply With Quote
  #4  
Old 01-09-2018, 03:10 PM
macropod's Avatar
macropod macropod is offline use different date format in a reference Windows 7 64bit use different date format in a reference Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You really need to pay closer attention to the field switch syntax: 'm' is for minutes; 'M' is for months...

in your first post, you said
Quote:
Originally Posted by MimiCush View Post
I would like to enter a date (say with a format of mmmm dd, yyyy) and bookmark it.
A switch with that format generates "minute day, year", which is why I said the date switch for the first field should be:
\@ "MMMM DD, YYYY"
not:
\@ "mmmm dd, yyyy"

You then said
Quote:
Originally Posted by MimiCush View Post
I would like to reference the bookmark but format it differently, not just the char format, but the date format (such as mm-dd-yy)
Again, switch with that format generates "minute day, year", which is why I said the date switch for the second field should be:
\@ "MM-DD-YY"

Instead of doing that, you've chosen to use:
\@ "mm-dd-yyyy"
Given that your switch tells Word to display minutes instead of months, it's hardly surprising you didn't get the results you expected.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 01-11-2018, 09:53 AM
MimiCush MimiCush is offline use different date format in a reference Windows 10 use different date format in a reference Office 2013
Novice
use different date format in a reference
 
Join Date: Jan 2018
Posts: 29
MimiCush is on a distinguished road
Default

Paul,

Yikes. Thank you.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
use different date format in a reference Can't format date to MM/DD/YY gogreen Excel 2 10-31-2016 03:24 PM
How to Create a Reference Style That Will Provide an author (date) citation djwalsh Word 3 03-17-2014 05:28 AM
Letter date changes when merging with Excel - not the format, the actual date! Smallweed Mail Merge 1 02-07-2014 06:00 PM
use different date format in a reference Reference number and cross reference for equation numbers to match the thesis format wmac Word 1 05-14-2013 08:54 PM
date format gsrikanth Excel 1 12-28-2011 05:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft