i want last 30 days of data in below date filed based on the satus

[chandra2]

Hi All,

I've tried loads of variations the following:

=count ({<[Status desc]={'Dispatched'},L3=-{'VOC','Registration','Customer Consultation'},[Partner Type desc]=-{'SSD'},
{$<X_DISPATCH_DATE = {"<$(=Date(today()-30))"} }>} [SR#])

i want last 30 days of data in X_DISPATCH_DATE based on above expression 

thanks,

Ravi

[settu_periasamy]

Hi,

Did you try this?

=count ({<[Status desc]={'Dispatched'},L3=-{'VOC','Registration','Customer Consultation'},[Partner Type desc]=-{'SSD'},X_DISPATCH_DATE = {"<$(=Date(today()-30))"} >} [SR#])