Find different values from specific dates

[sk5027383]

Hi.

We try to sort a list of activities.

We have two different activities called " DOK§4-18 varsel" and "DOK §7-10 varsel".

These are two different letters sent out to our customers. The first letter sent out to a customer is "4-18", and some of these customers receive the "7-10" letter as well. If they receive the "7-10" letter, the letter has to be sent to the customer within a year of the date the "4-18" letter was sent.

Our question is, is it possible to sort the customers who have received the "7-10" letter after a year has passed? 

Underneath is an example of how our table looks, "utført dato" is the date the letter was sent. 

[v-shex-msft · Accepted solution]

Hi @sk5027383,

I'd like to suggest you use activities name and sender id to find out records and stored in variable, then use minx and maxx functions with variable table to get first and last date.

Finally, you can simply use datediff to get diff from above result.

Regards,

Xiaoxin Sheng