VPF6: Character date to string 1

[maggielady]

I have a table with a character date field in this format: yyyymmdd, except that some of the dates are just mmdd. How do I get all of these dates into a string format that needs to go into another program that only excepts dates in this format yyyymmdd(character field 8 spaces)? Any help would be greatly appreciated!!

 

[jimstarr]

theyear = '2004' && default year

REPLACE ALL datefield with theyear + datefield FOR ;
LEN(ALLTRIM(datefield)) = 4


Jim