cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Find different values from specific dates

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. 

 

Skjermbilde.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Find different values from specific dates

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Find different values from specific dates

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors