Overdue Date

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Overdue Date

Viewing 3 reply threads
  • Author
    Posts
  • September 28, 2022 at 7:01 PM #48042

    ct4
    Participant

    Hi – I want to create a search that shows the date due is before “today”. At present I can only see a search rule that “is today”. In other words, I want a search that shows me the overdue bills. Thanks

    September 28, 2022 at 8:00 PM #48043

    Daniel Leu
    Participant

    I’m using a script field that calculates if something is due. Then I can search on this field.

    • This reply was modified 2 years, 2 months ago by Daniel Leu.
    • This reply was modified 2 years, 2 months ago by Daniel Leu.
    September 29, 2022 at 1:07 AM #48048

    Leo
    Participant

    Use a calculatie field “overdue”

    (today()- Date )/(24*60*60)-( Term )

    where Date is a datefield with the “start date” and Term is a numberfield with the Term you want to use (in number of days)

    September 29, 2022 at 2:08 AM #48049

    Brendan
    Keymaster

    Alternatively, let Tap Forms do the work for you and use the in the period comparison operator with the Before today setting.

  • Author
    Posts
Viewing 3 reply threads

You must be logged in to reply to this topic.