What is wrong with this expression? Trying to get items in the past 30 days

[#1]

I am trying to pull back a list of projects created in the past 30 days along with a couple of other conditions.  What is wrong with this expression?   Sum({$<CostGrp_IsActive = {'Yes'}, Trans_Type= {'D'},CostGrp_IsDetailed={'Detailed'},Created_Date >= {Date(Today()-30,'YYYY/MM/DD')}>}CostGrp_Contract_Amt)

[vinieme12]

Try below

Sum({$<CostGrp_IsActive = {'Yes'}, Trans_Type= {'D'},CostGrp_IsDetailed={'Detailed'},Created_Date = {">=$(=Date(Today()-30,'YYYY/MM/DD'))"}>}CostGrp_Contract_Amt)

[mkelemen · Accepted solution]

Hi,

I think you need to use

Created_Date = {">=$(=Today() - 30)"}

BR,

  Matus

[#4]

Thank you very much, however this resulted in no records coming back.

[#5]

Thank you, this worked perfectly.