topic Count with date difference as condition in App Development

Count with date difference as condition

Wed, 06 Jan 2016 05:25:50 GMT

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 — Wed, 06 Jan 2016 09:59:50 GMT

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

marcus_sommer — Wed, 06 Jan 2016 10:00:56 GMT

Try:

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

- Marcus

Wed, 06 Jan 2016 10:07:01 GMT

This counts all records in the table.

Wed, 06 Jan 2016 10:13:20 GMT

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

Thanks a lot Marcus!

Chanty4u — Wed, 06 Jan 2016 12:45:00 GMT

Hmmm