Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Hi,
I think you need to use
Created_Date = {">=$(=Today() - 30)"}
BR,
Matus
Try below
Sum({$<CostGrp_IsActive = {'Yes'}, Trans_Type= {'D'},CostGrp_IsDetailed={'Detailed'},Created_Date = {">=$(=Date(Today()-30,'YYYY/MM/DD'))"}>}CostGrp_Contract_Amt)
Hi,
I think you need to use
Created_Date = {">=$(=Today() - 30)"}
BR,
Matus
Thank you very much, however this resulted in no records coming back.
Thank you, this worked perfectly.