date field 2

[slim2]

Hello,

I have a field which is YYYYDDD the DDD is julian date. So 2002015 is 01/15/2002. I have tried every date conversion but cannot get it to work. Is there a way to convert this with a function.

Thanks in advance for any help.

 

[Ngolem]

how about try this
I will assume this is a string field,
"YYYYDDD" => {funnydate)

dateAdd("d",tonumber(right({funnyDate},3))-1,
date(tonumber(left({funnyDate},4)),01,01)

note I subtracted one from the DDD since our startdate is Jan 01 of the year Jim Broadbent

 

[rosemaryl]

Dear Slim2,

This one also works:

//assuming that funnydate is a string

stringvar y;
stringvar d;
y := mid({@funnydate},1,4);
d := mid({@funnydate},5,7);

DateSerial (tonumber, 1, tonumber(d))

Hi, NGolem...


ro
Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[slim2]

Hey Jim, and Ro,

Thanks very much for the help it worked perfectly. You guys are great!

Les