Yes, you can. See CTOD() and DTOC() functions. However, I would recomend that you change fields type in the table to the date.

>Hi Sergey,
>I removed the line "AND tableA.date = tableB.date" from the select statement and it ran it from the command window without errors and I checked to see if the name, type and width were the same and I found that the "Type" was changed from "date" to "Character". There are quite a few tables that are linked and data is inserted from one to another so what I have found is that the person who orginially wrote the code for this program had a field specficially for a date but he chose to designate the type of filed as a "Character" with a width of "10" instead of "Date" with the default width of "8". Is there a way that I can programatically change the type and width of my field (Set as type: "date")in the sql statement upon appending the records to match his?
>
>Select tableA.field5 as fieldtotal FROM tableA INNER JOIN tableB ON tableA.fieldname = tableB.fieldname AND tableA.date = tableB.date INTO cursor crsTemp
>
>>>Copy the select statement into the command window and try to run with one join condition at time.
>
>>When I choose "suspend" the debugger breaks at the first line of the select statement.
>>
>>>Which command gives you this error?
>>
>>>Hi Sergey,
>>>I am now getting an "Operator/Operand type mismatch" How do I determine which fields are causing this error? The fields are of the same name, type and width so could it be something else?
>>>
>>>>>Here's corrected code
>>>
>>>>>Select tableA.field5 as fieldtotal ;
>>> FROM tableA ;
>>> INNER JOIN tableB ON tableA.namefield = tableB.namefield ;
>>> AND tableA.datefield = tableB.datefield
>>> INTO cursor crsTemp
>>>
>>> SELECT mytable
>>> append from ( dbf('crsTemp') )