Within 2 weeks of a date

[brf10043]

If I have an "end of life date" column and I want to count Ids where the end of life date is within 2 weeks of today's date but not yet passed, what would the expression look like?

[lironbaram · Accepted solution]

hi 

it should be something like this : 

count (if(today() - [end of life]<14 and today()>=[end of life],id))

[brf10043]

Thanks Lironbaram!  I'll give that a try!

[brf10043]

Thanks Lironbaram,

What if I want to create a Pie or bar chart hat divides the data into the buckets?  What would the expression look like?

1 bucket for past date

1 bucket for 12 months until date

I bucket for 24 months until date.