Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need YYYYDDD to DATE() function. Anyone?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00468591
Message ID:
00468600
Views:
11
>I have a DATE() to YYYYDDD function already but I received a file full of YYYYDDD instead of dates and need to get dates.
>
>Does anyone havce a quick algorithm/function already? Before I waste time reinventing the wheel.
>
>TIA

How about
** cDate - The YYYYDDD date
LPARAMETER cDate
nYear = VAL( LEFT(cDate,4) )
nDay = VAL( RIGHT(cDate,3) )
dStart = CTOD( "12/31/" + TRAN( nYear - 1) )
RETURN dStart + nDay
OTH
Paul G Brown, MCSD
Paul G Brown
paul@paulgbrown.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform