range in where clause

hi Friends,

is it possible to add range in where clause , like this:

Select sum(AmountMSTSecond) from TurnoverCost where
TurnoverCost.AccountNum == ‘700000…7100000’

TurnoverCost.Dimension[4] == _Resno &&
TurnoverCost.TransDate >= FirstDate &&
TurnoverCost.TransDate <= TodayDate;

or any alternative

You can’t use “…” operator in X++ queries (you can if you rewrite it to the Query framework). You’re already using the right approach with the TransDate field.