>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}
date(2006, 12, 31)
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)