View Single Post
  #3  
Old May 5th, 2010, 03:07 PM posted to microsoft.public.access
MikeR
external usenet poster
 
Posts: 147
Default How do I get the date to display a Julian date? (yyddd)

Jacobs33Ladder wrote:
I am trying to get the date to show up as a Julian date, yyddd. In my form
and report I need to have both regular ddmmyyyy and yyddd fields. they are
the same day so if there is an expression that I can use to convert the first
date into the julian that would work as well.

Thanks


Being pedantic, but that is not a Julian date. I know a lot of IS people call it
that. See http://en.wikipedia.org/wiki/Julian_day
Mike