Retrieve the corresponding date

[gui_baudouin]

Hi,

My goal is to make a calculation between dates of type action = 'C' and dates of type action = 'D' (Date type action C - Date type action D)

I have to retrieve the type C date following the type D date (11/04/2019) and not the date before it (07/02/2019).

 I attached a small test file.

Thank you in advance for your help,

Cordially

[arpitkharkia · Accepted solution]

Hi,

I have attached the solution. I used PEEK() in the backend. I hope this helps!

[gui_baudouin]

Ok thank you so much for your answer.

I implement the code in my case and it works well. I just had to add another field in my Group By instruction because I deal with lot of data.

Thank you