AnsweredAssumed Answered

FM 16 Adv 203 - Find not right

Question asked by synergy46 on Oct 10, 2017
Latest reply on Oct 13, 2017 by synergy46

DuesLateLAYOUT.png

I have this little layout (above) based on Members::

The gStartDate and gEndDates are global date fields

There is a subsummary field based on Members::MemDuesStatus ('Current' or 'Late')

In the Body I have a portal from the Dues:: table

    The Dues::Date field is what I want to restrict using the gStartDate and gEndDate fields

CUrrentLateStart.png

When the script starts it produces All records and it looks like above.

 

But....

When I run the script associated with the 'go' button using the gStartDate and gEndDate fields, it fails....

 

CurrentOrLateDuesDates.png

 

... the result looks like this:

 

CurrentOrLateResultDate.png

 

As you can see, Bakker retains her Jun 2 2016 date

but

Oliver looses his 'out of range' dates.... huh?

 

Can you see what I am missing????

Outcomes