Calculation Between Two Dates Expression

[rafaeloneil]

Staff, Good evening,

I have a table:

I'm riding a PivotTable that need to have a field that Count how many contracts meet the following criteries:

• ((CodStatusBx = 0))
• Diference apart from days (Current Date - Date Contract) greater than 10 calendar days

This expression is not working for me
Count({$<CodStatusBx={0}>} fabs(Date(Today(),'DD/MM/YYYY')) - fabs(Date(DtContrato,'DD/MM/YYYY')))

Could help me?

[sunny_talwar · Accepted solution]

May be this:

Count({$<CodStatusBx={0}, DtContrato = {"$(='>=' & Date(Today() - 10, 'DD/MM/YYYY'))"}>} NuContrato)

[rafaeloneil]

Thanks for the tip at the end, I had to create the calculation in Table before loading the data to get the correct result, Thank you Sunny!