baweld123 Posted February 22, 2016 Share Posted February 22, 2016 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 Link to comment Share on other sites More sharing options...
comment Posted February 22, 2016 Share Posted February 22, 2016 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 Link to comment Share on other sites More sharing options...
baweld123 Posted February 22, 2016 Author Share Posted February 22, 2016 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? Link to comment Share on other sites More sharing options...
comment Posted February 22, 2016 Share Posted February 22, 2016 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? Link to comment Share on other sites More sharing options...
baweld123 Posted February 22, 2016 Author Share Posted February 22, 2016 sorry i misread !! Ill try again now well i would if i knew how to filter only forward dates. Link to comment Share on other sites More sharing options...
LaRetta Posted February 22, 2016 Share Posted February 22, 2016 portal filter would be similar to: retest date > Get ( CurrentDate ) Link to comment Share on other sites More sharing options...
baweld123 Posted February 22, 2016 Author Share Posted February 22, 2016 Thanks LaRetta, And thanks Comment i think its sorted :-))))) brilliant Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2979 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now