How to Filter Dates for a date that is greater than another date?
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.17Views0likes3CommentsHow to create a week date range with start and end if the week for each week?
Hi DRay Liliia_DevX , I am looking to create a week range for a line/column/bar chart where lets say it is the 30th week of 2024, then the 31st, 2024 and I want the 30th and 31 st week to shows Sep 24 - Sep 31 2024, etc. Is there a way to achieve this within the model or in the back end of a live data model.Solved117Views1like4Comments