topic Re: Create End dates based on next start date for a dimension in App Development

Create End dates based on next start date for a dimension

Iwin — Thu, 26 Sep 2024 07:31:41 GMT

Hi,

I have a requirement where I need to create end dates based on start dates.

I have explained the scenario below :

Here for Patient A ,the end date of Free Use is null but as Commercial Order Type started on 07 /07/2024 ,the End Date for Free Use should display date 1 day before the start date of Commercial Order Type i.e - 06/07/2024

For Patient B, there are 3 Order Types ,and there can be any number of Order Types for a Patient.

How to create the end dates in this scenario?

Re: Create End dates based on next start date for a dimension

VBD — Thu, 26 Sep 2024 08:01:16 GMT

Hello,

You can try something like : Test :
Load Patient,
[Order Type],
[Start Date],
if(Previous(Patient) = Patient and len([End date]) =0 , date(peek([Start Date],-1)-1),[End date]) as [End date]
Resident TMP
Order by Patient asc, [Start Date] desc;

Re: Create End dates based on next start date for a dimension

Iwin — Thu, 26 Sep 2024 08:21:22 GMT

Thank you for the quick reply and fix.