Compare two date fields, find the next greater date

[#1]

Hi all,

I have a problem:

I want to compare two date fields (date1 and date2) and get the next greater date of field date2.

The relationship between date1 and date2 is 1 to n.

The fields are linked via a Customer ID.

I tried something like that

if(date2>=date2,min(date2))

But this is not correct.

Any ideas about that?

Kind regards

Philipp

Message was edited by: Philipp Schöck I added a small example to explain my problem in more detail. Kind regards Philipp

[sunny_talwar]

I want to compare two date fields (date1 and date2) and get the next greater date of field date2.

I am not sure I understand this part "get the next greater date of field date2". Can you provide a sample to look at this in details?

[#3]

I try to explain:

The expression 'compared date' should display always the next greater date.

It should look into the field date2, look if there are dates later then in the field date1 and display the smallest of them.

[MayilVahanan · Accepted solution]

Hi

Are you looking like attachment?

[#5]

Thank you... this looks good!!