Hello , Im hoping somebody can help me :-). I have a portal on my customers layout its a single date field portal. This portal is connected to my service layout.

The Field shows the retest date of a piece of equipment . It works perfectly if there is only one retest date. My problem is if there is many.

What i would like the portal to show is the NEXT retest date . At the moment it shows the LAST retest date. So if i have a customer with many machines tested on different dates it always shows the LAST which means i miss the retest dates in-between the current date and this last retest date.

I hope that makes sense. 

Thanks

 

 

If you filter the portal (or the relationship) to show only future dates, you can then sort the portal (or the relationship) by date, ascending - making the next date appear in the first portal row.

Another option: http://www.briandunning.com/cf/1266

Hi , Thanks for the quick reply but the ascending doesnt work for me , I have it set at descending at the moment so that the last retest date is showing. I looked at the Function route on the link but to be honest i havent a clue what to do there :-) I have never done a function. I tried to copy and past it but it didnt work? 

3 hours ago, baweld123 said:

the ascending doesnt work for me

I said it will work if you filter the portal to show only future dates. Have you done that? If yes, in what way exactly it "doesn't work"? If not, why not?

sorry i misread !! Ill try again now 

well i would if i knew how to filter only forward dates.

portal filter would be similar to:

retest date > Get ( CurrentDate )

Thanks LaRetta, And thanks Comment i think its sorted :-))))) brilliant