# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

## Calculation Between Two Dates Expression

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?

1 Solution

Accepted Solutions
MVP

## Re: Calculation Between Two Dates Expression

May be this:

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

2 Replies
MVP

## Re: Calculation Between Two Dates Expression

May be this:

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

New Contributor III

## Re: Calculation Between Two Dates Expression

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!

Community Browser