And, this gets the Julian Date-Time

VB Code:
  1. Option Explicit
  2.  
  3.  
  4.  
  5. Private Sub Form_Load()
  6.  
  7.     MsgBox CalcJDate(#10/9/1995 12:00:00 PM#)
  8.     'MsgBox CalcJDate(Date)
  9.     Unload Me
  10. End Sub
  11.  
  12.  
  13. Private Function CalcJDate(ByVal nDateTime As Date) As Double
  14.  
  15.     Dim mm As Double
  16.     Dim dd As Double
  17.     Dim yy As Double
  18.     Dim hr As Double
  19.     Dim mn As Double
  20.     Dim gg As Double
  21.     Dim s As Double
  22.     Dim jd As Double
  23.     Dim a As Double
  24.     Dim j1 As Double
  25.         mm = Month(nDateTime)
  26.     dd = Day(nDateTime)
  27.     yy = Year(nDateTime)
  28.    
  29.     hr = Hour(nDateTime)
  30.     mn = Minute(nDateTime)
  31.    
  32.     hr = hr + (mn / 60)
  33.     gg = 1
  34.     If yy < 1585 Then
  35.         gg = 0
  36.     End If
  37.     jd = -1 * ((7 * ((mm + 9) / 12) + yy) / 4)
  38.     s = 1
  39.     If (mm - 9) < 0 Then
  40.         s = -1
  41.     End If
  42.     a = Abs(mm - 9)
  43.     j1 = (yy + s * (a / 7))
  44.     j1 = -1 * (((j1 / 100) + 1) * 3 / 4)
  45.     jd = jd + (275 * mm / 9) + dd + (gg * j1)
  46.     jd = jd + 1721027 + 2 * gg + 367 * yy - 0.5
  47.     jd = jd + (hr / 24)
  48.    
  49.     CalcJDate = jd
  50.    
  51. End Function

Why not use the Date-Time Picker to let the user select a date?