>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?
ln_yyyyddd = 2000316
ld_year = INT(ln_yyyyddd / 1000)
ld_days = MOD(ln_yyyyddd, 1000)
? DATE(ld_year, 1, 1) + ld_days - 1
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers