Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-29-2012, 06:16 AM
ragesz ragesz is offline Field DOCPROPERTY LastSavedTime format problem Windows 7 64bit Field DOCPROPERTY LastSavedTime format problem Office 2007
Novice
Field DOCPROPERTY LastSavedTime format problem
 
Join Date: Oct 2012
Posts: 14
ragesz is on a distinguished road
Default Field DOCPROPERTY LastSavedTime format problem

Hi all,

What is the date/time format of the field DOCPROPERTY LastSavedTime? If I insert { DOCPROPERTY LastSavedTime \* MERGEFORMAT } I get the full time and date of the last saving in this format: yyyy.MM.dd. H:mm. This is 2012.10.26. 16:05. But I want only this: yyyy.MM.dd. so 2012.10.26. Not more. How can I get it? I tried { DOCPROPERTY LastSavedTime \@ "yyyy.MM.dd." \* MERGEFORMAT } but I got this: 2016.10.26. I don't know why, but the date and time format changes something like this: yyH.MM.dd. Do you know why and how to get the right value? I tried it in Office 2007 and Office 2010 english version on another PC, and the same problem occurs.
If I format CreateDate filed, it is ok, every attribute (yyyy.MM.dd.) works properly. But when I format DOCPROPERTY CreateTime, the same problem occurs like LastSavedTime. { DOCPROPERTY CreateTime \* MERGEFORMAT } shows this: yyyy.MM.dd. H:mm ( 2011.05.09. 10:15 ). But { DOCPROPERTY CreateTime \@ "yyyy.MM.d." \* MERGEFORMAT } shows this: yyMM.dd.H ( 2005.09.10. )

Can you help me to resolve this issue? The date format yyyy.MM.dd or dd.MM.yyyy or MM.dd.yyyy is not relevant.
Thank you!!!!!!
Reply With Quote
  #2  
Old 10-29-2012, 06:31 AM
macropod's Avatar
macropod macropod is offline Field DOCPROPERTY LastSavedTime format problem Windows 7 64bit Field DOCPROPERTY LastSavedTime format problem Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Why not use the SAVEDATE field? {SAVEDATE \@ "YYYY.MM.DD"}
A bit simpler than {DOCPROPERTY LastSavedTime \@ "YYYY.MM.DD"} (which works just as well).

You don't need the \* MERGEFORMAT switch.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-29-2012, 06:41 AM
ragesz ragesz is offline Field DOCPROPERTY LastSavedTime format problem Windows 7 64bit Field DOCPROPERTY LastSavedTime format problem Office 2007
Novice
Field DOCPROPERTY LastSavedTime format problem
 
Join Date: Oct 2012
Posts: 14
ragesz is on a distinguished road
Default

Ohh, I'm new in using fields... I didn't know (notice) that there is a filed SaveDate
It is great for me, thank you!!!

But is there any explanation to my issue? Using english date format, does it occurs?
Reply With Quote
  #4  
Old 10-29-2012, 06:50 AM
macropod's Avatar
macropod macropod is offline Field DOCPROPERTY LastSavedTime format problem Windows 7 64bit Field DOCPROPERTY LastSavedTime format problem Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

I am unable to reproduce the problem you described. With {DOCPROPERTY LastSavedTime \@ "YYYY.MM.DD"} I get 2012.10.16 (in a document last saved a few weeks ago) and, AFAIK, all english-language installations work the same. Do note that 'M' is for months and 'm' is for minutes.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 10-29-2012, 06:58 AM
ragesz ragesz is offline Field DOCPROPERTY LastSavedTime format problem Windows 7 64bit Field DOCPROPERTY LastSavedTime format problem Office 2007
Novice
Field DOCPROPERTY LastSavedTime format problem
 
Join Date: Oct 2012
Posts: 14
ragesz is on a distinguished road
Default

I changed the Language format to English (UK) in Control Panel (so date is 29/10/2012). And everything works well in Word. I'm Hungarian, and it seems that using Hungarian language format in Windows 7, the Word DOCPROPERTY LastSavedTime and CreateTime works wrong.

Thank you again for SaveDate!!!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Field DOCPROPERTY LastSavedTime format problem changing date format in Bibliography field elly111sk Word 3 07-25-2012 06:54 PM
Field DOCPROPERTY LastSavedTime format problem Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM
Field DOCPROPERTY LastSavedTime format problem Problem with field in header oteixeira Word 1 08-31-2011 01:44 AM
Field DOCPROPERTY LastSavedTime format problem ASK and REF field problem ilkks Word 3 05-26-2011 01:58 AM
Format Problem sri00 Word 0 07-06-2010 05:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:00 PM.


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