treds Posted May 14, 2007 Share Posted May 14, 2007 Hi can anyone help me I am trying to find, sort records between different dates. start_date and a End_date but I cannot get it to do it correctly. I can't not upload because its to big What gladly email someone ! : Link to comment Share on other sites More sharing options...
Ender Posted May 14, 2007 Share Posted May 14, 2007 Can you be more specific about the problem? If you can't upload a sample file, maybe you could at least supply some example data and specify what should be found and how it should be sorted (Finding and Sorting are different operations). Link to comment Share on other sites More sharing options...
treds Posted May 15, 2007 Author Share Posted May 15, 2007 Hi Ender Thanks for the reply I uploaded the file 2 layouts 1 is the delivery note 2 is the calculation i am trying to do I am trying to sort on 2 dates and view the amount of orders that have gone out between those dates DeliveryNote_copy.zip Link to comment Share on other sites More sharing options...
Ender Posted May 15, 2007 Share Posted May 15, 2007 Hey treds, You should probably not post actual data to a public forum. I looked at your file and saw what you are trying to do. You have the correct idea for a range-to-date relationship. To include the start and end dates in the range it would be: Interface::gStartDate <= Data::Date AND Interface::gEnd Date >= Data::Date However, there is something else going on with your file that makes this not work consistently (depending on which record you're on on the parent side). Since the fields on the parent side are globally stored, it shouldn't matter what record you're on; you should always see the correct matching records in the portal. In this case, I was sometimes seeing records outside the date range, and sometimes having records missing from the date range. I tried reindexing, replacing fields, redoing the relationship, and compressing the file, but I still get the wrong related records showing up sometimes. I'm not sure what the problem is. Link to comment Share on other sites More sharing options...
Ender Posted May 15, 2007 Share Posted May 15, 2007 Check that--I think it's working now in the compressed version. Try 'Save a Copy As (compressed)', hopefully that will solve it for you too. Link to comment Share on other sites More sharing options...
treds Posted May 15, 2007 Author Share Posted May 15, 2007 Thanks Ender Could you attach the file so I can follow what u done Thanks again Link to comment Share on other sites More sharing options...
treds Posted May 16, 2007 Author Share Posted May 16, 2007 Hi Ender Could you post the file to me Thx Link to comment Share on other sites More sharing options...
Ender Posted May 16, 2007 Share Posted May 16, 2007 Sorry, I don't have access to it right now. Maybe tomorrow. Link to comment Share on other sites More sharing options...
Ender Posted May 17, 2007 Share Posted May 17, 2007 Attached is clone of your file with the correct relationship. DeliveryNote2.fp7.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6189 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