Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-19-2014, 12:00 AM
Jamal NUMAN Jamal NUMAN is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Nov 2010
Posts: 615
Jamal NUMAN is on a distinguished road
Question Inserting “date & time” for the year (YYYY) only,

Inserting “date & time” for the year (YYYY) only,

I couldn’t figure out how can I insert a “date & time” that contains year only (YYYY) like 2014 (attached).

I’m not sure if this can by managed if the date is inserted from fields (attached). But in this case, the date will never be updated automatically but needs to click “update field” option.

Thank you

Best



Jamal
Attached Images
File Type: jpg Clip_24.jpg (243.5 KB, 19 views)
File Type: jpg Clip_23.jpg (212.5 KB, 19 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Date field inserting merge date in blank field Lesley Mail Merge 5 09-30-2013 01:49 AM
How to call current PC date and/or current PC year KIM SOLIS Excel 2 11-04-2011 06:09 PM
How to count year lapse (rounded off) based on specific date KIM SOLIS Excel 1 11-01-2011 10:50 AM
Creative Ways for a year-to-year comparison??? ridonkulous5 Excel 1 03-23-2011 04:49 PM
YYMMDD to YYYY-MM-DD Alexander Excel 1 01-18-2010 01:22 PM

Other Forums: Access Forums

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