Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Julin Dates

Status
Not open for further replies.
ryan1

ryan1

Programmer
May 15, 2002
106
US
Does anybody know how to change a date to a Julin Date??I Need Some Help
 
Sort by date Sort by votes
Public Function JulianDate(MyDate As Variant) As Long


MyDate = Forms!MyForm![Date Generated]
If IsNull(MyDate) Then Exit Function
JulianDate = Right$("000" & DatePart("y", MyDate), 3)

End Function
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Xscatolare
  • Locked
  • Question
Group by ID and determine consecutive dates 1
Replies
6
Views
150
Xscatolare
Xscatolare
ali32uk
  • Locked
  • Question
If between 2 dates then colour text box
Replies
4
Views
133
missinglinq
missinglinq
MrMode
  • Locked
  • Question
Argh - Dates keep flipping to US format 2
Replies
9
Views
350
MajP
MajP
newguy86
  • Locked
  • Question
Broadcast Dates Query/Table 2
Replies
10
Views
177
newguy86
newguy86
tranchemontaigne
  • Locked
  • Question
MS Access-MS Excel integration corrupt dates
Replies
3
Views
75
tranchemontaigne
tranchemontaigne

Part and Inventory Search

Sponsor

Back
Top