hi,
thank you,
it try as under, but no result, i'm sure about data

CLOSE ALL
USE test
brow&&i can see my data(found)
ldStart =ctod("01/01/2006")
ldEnd = ctod("31/12/2006")

SELECT stk_code,trn_type,trn_date,cst_prce,str_nmbr, ;
	SUM(IIF(MONTH(trn_date)=1 AND trn_type=1,trn_qnty, 000000)) AS m1_t ;
	FROM test ;
WHERE between(trn_date,ldStart,ldEnd)&&no result
WHERE between(trn_date,date(2006, 12, 31))  ;error 
GROUP BY stk_code,trn_type,trn_date,cst_prce,str_nmbr

tanks.
>>hi all,
>>i try this code it works for one time, i try again i get error message Command contains unrecognized phrase/keyword
>>

>>ldStart =ctod("01/01/2006")
>>ldEnd = ctod("31/12/2006")
>>
>>SELECT stk_code,trn_type ;
>>	SUM(IIF(MONTH(trn_date)=1 AND trn_type= 44, trn_qnty, 000000)) AS m1_t ;
>>	FROM test ;
>>WHERE between(trn_date,ldStart,ldEnd) ;
>>GROUP BY stk_code,trn_type
>>brow
>>

>>thanks
>
>Don't use ctod() to get date constants. This command is ambiguous - the result may depend on SET DATE and SET CENTURY.
>
>Instead, use one of the following:
>
>

>{^2006-12-31} && unambiguous date constant
>date(2006, 12, 31) && unambiguous date expression
>