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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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