Hi DRay , intapiuser , JeremyFriedel I am trying to see the count of a column where the date from one field is greater than the date from another date. Here is my example: Table: Program_Plan_of_care_goal Field: Count (Goal_code) and Goal_actual_completion_date > Goal_target_completion_date I would assume I could achieve this with a CASE WHEN formula but this does not seem to get what I am looking for.

I actually achieve this by doing a CASE WHEN statement CASE WHEN MAX(DDIFF(Goal_actual_completion_date, Goal_target_completion_date)) > 1 THEN COUNT(Goal_code) ELSE 0 END. DRay Seems like there are multiple answers to this quetion Cause and Effect Strategy Senior Data Analyst Sisense Partner

How to Filter Dates for a date that is greater than another date? | Help and How-To

MoreDiscussions

How to Filter Dates for a date that is greater than another date? | Help and How-To | Sisense Community