My flat file shows a 2 digit year (99347). I did get this converted, but now need to convert the user's input from mm/dd/yyyy to julian to match against the file. Oh what a tangled web we weave! Anyway, should I try to do that using CDate?<br>
<br>
Here is my code to convert my julian date to the printable data:<br>
Sub Convert_date()<br>
Dim dtmNewDate As Date<br>
Dim strJulianDate As String<br>
strJulianDate = wrkRqmtDate<br>
dtmNewDate = DateSerial(Left$(strJulianDate, 2), 1, 1)<br>
dtmNewDate = DateAdd("d", Val(Right$(strJulianDate, 3)) - 1, dtmNewDate)<br>
wrkRqmtDate = ""<br>
wrkRqmtDate = Format(dtmNewDate, "mm/dd/yyyy"

<br>
End Sub