Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Are you looking like attachment?
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?
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.
Hi
Are you looking like attachment?
Thank you... this looks good!!