Sorry for the double post. This post is also in Outlook Calendaring.
I didn't see Ken's post, until after I submitted the below as a general
comment on 1/18/2007.
To All,
I just did a search, and found several posts requesting how to use Julian
dates in Outlook. The post and the replies have disappointed Outlook users
since at least 2004, in that the replies have stated that it is not possible
to use JDs in Outlook.
Like many users, I work with the government, and often need JDs. I have only
recently begun posting to the MS Discussion groups, but last year, I found
out how to use Julian Dates within outlook, so here is my solution; better
late than never.
===
It is possible to create a julian date field for outlook 2000-2003 via a
user defined field. This field can be used in any tabular display (list).
Tabular displays will not sort on a user defined field. To the best of my
knowledge this field cannot be added to any calendar view. (Perhaps a form
expert can figure it out.)
Field Name: YYYY-JulianDay
Field type: Formula
Formula: (Year([Start]) & "- " & DateDiff("y",("01" & "/" & "01" & "/" &
(Year([Start]))),([Start]))+1)
The formula was derived from an Excel formula for calculating Julian dates.
The formula uses several outlook date functions, to generate a four digit
year followed by a 0-3 digit julian date. I added the year to ensure that
when I scan a list I can pick out the annual changes.
Example: 2007-199
I haven't figured out how to generate a 3 digit JD field. e.g., 009, 085,
etc.
I think it can be done by adding a format function to the formula (A big cry
of HELP, to the formula gurus)
--
Tom Conrad
===
Ken said:
Is there anyway to get the Outlook calendar to show Julian dates? Is there
another calander program to download that will work with Outlook?
