Greater than today date

[MK9885]

Hi,

I've a requirement where I need to show the count where the dates are greater than today.

I've a field name ENDDDATE and I've to count the ENDDATE where it is greater than today date.

I've tried count({<Date={">=Today())>ENDDATE"}>}distinct( Dimension))

and

Count({$<ENDDATE={">=$(date(Today())"} >} Dimension) but the count doesn't matches for some reason.

Can anyone please help?

And my DateFormat='YYYY-MM-DD' both in script and master calendar.

stalwar1‌swuehl‌loveisfail‌

[MK9885]

I'm confused on why is it not selecting

2017-06-20

2017-09-07 from ENDDATE?

they both are greater than today, right?

Why is not the part of selection and why 2016 dates are getting selected?

That is my question

Cus I'm only counting 2017 dates because all 2016 dates are passed.

[sunny_talwar]

Well this is just association that you have in your application. That particular customer is associated with those dates. But when we are doing a count in your expressions, the values are coming as they suppose to, right? 1st customer is not associated with 2017-06-20 and 2017-09-07. Why is it not associated? I don't know and I can't say unless I take a deep dive into your application. But right now, the first guy is not associated with those dates and isn't getting counted.

Does that make sense?

[MK9885]

That makes sense to me now, thanks.

And if I only wanted to count the start dates then the expression should be

count({<EMPLRECORDID>}DISTINCT(STARTDATE))???

Right?

[sunny_talwar]

I guess so, This expression is count DISTINCT STARTDATE ignoring selection in EMPLRECORDID. If that's what you want, then this looks good

[MK9885]

Got it.

Thanks a alot!!!