character date to date fields

[powerprinting]

I have a field that is character containing dates...

Ex: 19991102

I want to convert this to a date field...

whats the proper syntak to convert this field to another fields of proper date?

 

[SGLong]

Try this:

lcDate = "1991102"

ldDate = func_str2date(lcDate)
? ldDate


FUNCTION func_str2date
LPARAMETERS tStr
RETURN CTOD(SUBSTR(tStr,5,2)+"/"+SUBSTR(tStr,7,2)+"/"+LEFT(tStr,4))

Steve

 

[dbMark]

What SGLong gave you was the longhand reverse version of DTOS(). Strange that there is no simple reversed function. Just keep in mind:

(1) your current VFP date type (SET DATE TO AMERICAN, MDY, YMD, DMY, etc.) may require a different ordering of the substrings.

(2) this works fine if the century is included. If the century is not included, then the code would have to be adjusted so the century is calculated.

dbMark