Something like this:

lc="2000316"
lcdate=SYS(10,VAL(SYS(11,DATE(VAL(LEFT(lc,4)),1,1)+VAL(RIGHT(lc,3))-1)))

And format lcdate as needed.

Good Luck


>I have a numeric field that is actually a date. The format is YYYYDDD (ie,2000316). I want to convert this to MMDDYYYY format. What is the code for doing this?