Help!

How can I get Julian dates to display on the Outlook calen..

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Calendar RSS
Next:  Cannot find calendar  
Author Message
Ken
External


Since: Sep 05, 2004
Posts: 357



PostPosted: Tue Jul 17, 2007 6:50 pm    Post subject: How can I get Julian dates to display on the Outlook calendar?
Archived from groups: microsoft>public>outlook>calendaring (more info?)

Is there anyway to get the Outlook calendar to show Julian dates? Is there
another calander program to download that will work with Outlook?
Back to top
Brian Tillman
External


Since: Mar 29, 2005
Posts: 20866



PostPosted: Wed Jul 18, 2007 12:56 am    Post subject: Re: How can I get Julian dates to display on the Outlook calendar? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
Back to top
Ken
External


Since: Sep 05, 2004
Posts: 357



PostPosted: Wed Jul 18, 2007 12:56 am    Post subject: Re: How can I get Julian dates to display on the Outlook calendar? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"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
>
Back to top
Tom Conrad
External


Since: Jul 02, 2007
Posts: 91



PostPosted: Wed Jul 18, 2007 10:44 pm    Post subject: RE: How can I get Julian dates to display on the Outlook calendar? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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?
Back to top
Tom Conrad
External


Since: Jul 02, 2007
Posts: 91



PostPosted: Wed Jul 18, 2007 10:46 pm    Post subject: RE: How can I get Julian dates to display on the Outlook calendar? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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?
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Calendar All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum