Julian day

Hi, I need to convert a  date to a julian day..  any ideas....
DelboyAsked:
Who is Participating?
 
lyonstCommented:
0
 
planoczCommented:
Hi Delboy,
 One way to do J dates is with date format,
  Dim SDate as string
      SDate= format(sdate, "yyy")
  This will give you the Julian date with the year on the front of it.
0
 
DelboyAuthor Commented:
FAB  thanks for your help
0
 
tureCommented:
Delboy,

This little function will give you the julian date, always with 5 digits, in the format YYDDD.

Function Julian(d As Date) As String
  Julian = Format(d,"YY") & Format(D-DateSerial(Year(d)-1,12,31),"000")
End Function

Ture Magnusson
Karlstad, Sweden
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.