Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Sunday, December 31, 2006 – Permalink –

Date and Time; Field Codes

All you Need



One of the best forums relating to Office applications is Woody Leonard's WOPR.com.

In the Lounge area, "macropod" has a downloadable document that demonstrates Date and Time calculations in Word:


WORD Date & Time Manipulation: Tips & Techniques


Topics covered include:

  • Converting Gregorian Calendar Dates To Julian Day Numbers
  • Converting Julian Day Numbers To Gregorian Calendar Dates
  • Converting Julian Calendar Dates To Julian Day Numbers
  • Converting Julian Day Numbers To Julian Calendar Dates
  • Converting Between Julian Calendar Dates And Gregorian Calendar Dates
  • Converting Julian Day Numbers To Days Of The Week
  • Convert A Gregorian Calendar Date To A Day Of The Week
  • Converting Between Dates and Days of The Year
  • Automatically Insert A Past Or Future Date, Adjusted By +/- A Number Of Days, Weeks etc,
  • Interactively Calculate A Past Or Future Date
  • Date Calculations In A Mailmerge
  • Date Calculations In A Table
  • Express Today's Date In Fiscal Year Terms
  • Calculate The # Days Difference Between Two Dates
  • Calculate The Last Day Of This Month
  • Calculate The First Day Of Next Month
  • Calculate The # Years, Months & Days Difference Between Two Dates
  • Calculate A Person's Age
  • Calculate A Stepped Date
  • Calculate A Stepped Date Range
  • Calculate Western And Orthodox Dates Of Easter
  • Use Date (And/Or Time) Comparisons To Vary Text
  • Converting Date Strings Into Word Date Formats
  • Importing Date And Time Values From Excel And Access
  • Add Or Subtract Two Time Periods
  • Automatically Calculate A Past Or Future Time Of Day




See all Topics

Labels:


<Doug Klippert@ 5:13 AM

Comments: Post a Comment