A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Calandaring
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How can I get Julian dates to display on the Outlook calendar?



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old July 17th 07, 11:50 PM posted to microsoft.public.outlook.calendaring
Ken
external usenet poster
 
Posts: 84
Default How can I get Julian dates to display on the Outlook calendar?

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  
Old July 18th 07, 02:56 AM posted to microsoft.public.outlook.calendaring
Brian Tillman
external usenet poster
 
Posts: 17,452
Default How can I get Julian dates to display on the Outlook calendar?

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  
Old July 18th 07, 04:32 AM posted to microsoft.public.outlook.calendaring
Ken
external usenet poster
 
Posts: 84
Default How can I get Julian dates to display on the Outlook calendar?



"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  
Old July 19th 07, 03:44 AM posted to microsoft.public.outlook.calendaring
Tom Conrad
external usenet poster
 
Posts: 7
Default How can I get Julian dates to display on the Outlook calendar?

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  
Old July 19th 07, 03:46 AM posted to microsoft.public.outlook.calendaring
Tom Conrad
external usenet poster
 
Posts: 7
Default How can I get Julian dates to display on the Outlook calendar?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
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


All times are GMT +1. The time now is 12:54 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.