Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 444
  • Last Modified:

Julian day

Hi, I need to convert a  date to a julian day..  any ideas....
0
Delboy
Asked:
Delboy
1 Solution
 
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now