Need YYYYDDD to DATE() function. Anyone? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Need YYYYDDD to DATE() function. Anyone?

Message

From

25/01/2001 13:06:36

Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States

To

25/01/2001 12:38:42

Alex Feldstein
Florida, United States

General information

Forum:

Visual FoxPro

Category:

Coding, syntax & commands

Title:

Re: Need YYYYDDD to DATE() function. Anyone?

Miscellaneous

Thread ID:

00468591

Message ID:

00468624

Views:

13

>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

ldNewDate = CTOD([01/01/] + LEFT(JulianField, 4)) + VAL(RIGHT(JulianField, 3)) - 1

Click here to load this message in the networking platform