>>>In my Employee table sample, the Birth_date field is of type Date. I think that exist something around it.
>>
>>No Erick,
>>It happens with datetime fields consistently (it was a quick sample to send here. In original code I hit this the field was really a datetime field).
>>
>>SELECT emp_id, DTOT(birth_date)+3600 as bdate ;
>> FROM (_samples+'data\employee') ;
>> INTO CURSOR crsDummy nofilter
>>SELECT emp_id,EVL('dummy',TTOC(bdate)) as bdate FROM crsDummy
>>
Cetin
>
>Why would you expect 'dummy' to be empty to start with? Should it be
>evl(ttoc(bDate),'dummy') instead?
I don't expect anything:) I only found a case where it causes C...5 where it shouldn't.
Cetin