find sort by date script

[treds]

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

[Ender]

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

[treds]

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

[Ender]

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.

[Ender]

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.

[treds]

Thanks Ender

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

Thanks again

[treds]

Hi Ender Could you post the file to me

Thx

[Ender]

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

[Ender]

Attached is clone of your file with the correct relationship.

DeliveryNote2.fp7.zip