View Single Post
  #2  
Old May 5th, 2010, 12:19 PM posted to microsoft.public.access
Maarkr
external usenet poster
 
Posts: 240
Default How do I get the date to display a Julian date? (yyddd)

next time try a simple search for it on this site...
this was given by Karl Dewey
Format(Date(), "yy") & Format(DatePart("y", Date()), "000")


"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