problem with date

[bbmmouha]

hello

i want to add an indicateur whith date

i try this

=sum({<mois_a = MonthStart(Today())>} AMOUNT#LOCAL#1)

i want to the sum of amount between the star of month and actual date

thank you

[MK_QSL]

=sum({<mois_a = {">=$(=MonthStart(Today()))<=$(=Today())"}>} AMOUNT#LOCAL#1)

Hope mois_a is date field

[bbmmouha]

it 's always zero 0

this didn't work my be because date form is YYYYMMDD

[sunny_talwar]

Then add date format to your expression

=Sum({<mois_a = {">=$(=Date(MonthStart(Today()), 'YYYYMMDD'))<=$(=Date(Today(), 'YYYYMMDD'))"}>} AMOUNT#LOCAL#1)