![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
![]()
Is there anyway to get the Outlook calendar to show Julian dates? Is there
another calander program to download that will work with Outlook? |
#2
|
|||
|
|||
![]()
Ken wrote:
Is there anyway to get the Outlook calendar to show Julian dates? No. Is there another calander program to download that will work with Outlook? None that I know. Only Outlook can access Outlook calendars and I don't know of any other calendar program that will access Outlook's data files. -- Brian Tillman |
#3
|
|||
|
|||
![]() "Brian Tillman" wrote: Ken wrote: Is there anyway to get the Outlook calendar to show Julian dates? No. Is there another calander program to download that will work with Outlook? None that I know. Only Outlook can access Outlook calendars and I don't know of any other calendar program that will access Outlook's data files. -- Brian Tillman Thank you for your time and answer. Ken |
#4
|
|||
|
|||
![]()
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" wrote: Is there anyway to get the Outlook calendar to show Julian dates? Is there another calander program to download that will work with Outlook? |
#5
|
|||
|
|||
![]()
oops make that inital post date for my general comment, 7/18/2007
-- Tom Conrad "Tom Conrad" wrote: 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" wrote: Is there anyway to get the Outlook calendar to show Julian dates? Is there another calander program to download that will work with Outlook? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Display Julian Dates in Outlook | sorennelson | Outlook - Calandaring | 0 | June 22nd 06 02:39 PM |
Outlook should be able to display the julian date on calendar | mrsturgeon | Outlook - Calandaring | 0 | April 2nd 06 07:31 PM |
How do I get my Outlook calendar to show Julian dates? | drdmas | Outlook - Calandaring | 1 | February 27th 06 07:35 PM |
Julian dates on the Outlook calendar? | Marty | Outlook - Calandaring | 1 | February 23rd 06 04:19 AM |
will outlook display julian dates | JHA | Outlook - Calandaring | 1 | January 13th 06 03:15 PM |