lcDate = "1996100"
lcYear = Left(lcDate, 4)
lnDay = Val(Left(lcDate, Len(lcDate) - 4))
SET CENTURY ON
SET DATE TO YMD
ldDate = CToD(lcYear + "/01/01") + lnDay - 1
HTH
>I have to convert character fields that are stored as YYYYDDD to a standard date type. Is a simple way to do this?
>
>For example 1996100 would be the 100th day of 1996.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only