Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date Conversion
Message
From
18/12/1998 08:37:33
 
 
To
18/12/1998 08:27:40
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00168799
Message ID:
00168806
Views:
24
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
Map
View

Click here to load this message in the networking platform