>how do you convert a str to date data type ?

If you have date as a string in format YYYYMMDD, then small function may help:

Function StoD
Parameters cString

Return Ctod(Substr(cString,5,2)+"/"+Right(cString,2)+"/"+Left(cString,4))