How do I get the date to display a Julian date? (yyddd)

  • Thread starter Thread starter Jacobs33Ladder
  • Start date Start date
J

Jacobs33Ladder

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
 
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 said:
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
Click to expand...

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
 
Back
Top