Count with date difference as condition

[#1]

Hello!

Here is my sample data:

I want to count the records that fits the condition: Date B - Date A <= 180

I tried a number of expressions but none work:

• count(distinct if((date([Date B])-date([Date A])) <= $(180),[ID]) >>  nothing is displayed?
• count(distinct {$<[Date B] = { <=$(=<date([Date A]+180)) } >} [ID]) >>  counts all records (result = 20)
• count(distinct {$<[Date B] = {" <=$(=<date([Date A]+180)) "} >} [02_Full_name]) >>  result = 0

Please help!

[Chanty4u]

count(distinct {$<date[Date B] = { <=$(=<date([Date A]+180)) } >} [ID]) >>

[marcus_sommer · Accepted solution]

Try:

count(if([Date B]-[Date A] <= 180, [ID])

- Marcus

[#4]

This counts all records in the table.

[#5]

This works perfectly! How come I didn't think of this...

Thanks a lot Marcus!

[Chanty4u]

Hmmm