Mohammed,

Change to

WHERE between(trn_date,date(2006, 1, 1),date(2006, 12, 31))  

>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
>>