Jullian Date

  • Thread starter Thread starter Chris Savedge
  • Start date Start date
C

Chris Savedge

How do you convert a Julian date (04001) to a traditional date (01/01/2004)

Thanks,
chris
 
strJD="04001"
intYear = cint(20 & Left$(strJD, 2))
intJDDays = cint(Mid$(strJD, 3))
dtmDate = DateAdd("d", intJDDays, DateSerial(intYear-1, 12, 31))

....or something like that.
--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting
How do you convert a Julian date (04001) to a traditional date (01/01/2004)

Thanks,
chris
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to convert 2007-001 this year and day to a normal date? 1
Access Running Balance in Access 1
Converted from LINUX time ok, but having issues with the between date. 4
Julian Date conversion 9
Help with julian date? 2
Create List of Dates that fall between 2 Dates 2
need to show blank values 4
Running Balance (Debit and Credit) in Access 2007 4

Back
Top