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 12:46:24

Ed Rauh
Trumbull, Connecticut, 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:

00468601

Views:

17

>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.

CvtYYYYDDD2Date(tcYYYYDDD)
LOCAL nDays
nDays = VAL(SUBST(tcYYYYDDD,5))
RETURN EVAL('{^'+LEFT(tcYYYYDDD,4)+'-01-01}') + nDays - 1

>
>TIA

EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater

NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys

Click here to load this message in the networking platform