Jump to content
Sign in to follow this  
treds

find sort by date script

Recommended Posts

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 ! :

Share this post


Link to post
Share on other sites

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).

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Thanks Ender

Could you attach the file so I can follow what u done

Thanks again

Share this post


Link to post
Share on other sites

Sorry, I don't have access to it right now. Maybe tomorrow.

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.