Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.
Juggernaut

past due date

Joel_112
in Calculation Engine (Define Fields)

Featured Replies

  • Newbies

I new to these forums, and I hope I can explain myself correctly.

I have an invoice data base and in one layout I'm able to see what invoices are unpaid and outstanding.

These are the fields I'm using:

invoice

inv_date

inv_datePaid

invElsaped calculation > If(inv_datePaid="","", inv_datePaid - inv_date)

When I'm paid, I enter the date in the inv_datePaid field and I can see how many days have past...this works fine.

I have created a new layout for receivables ...My terms are net 30 days,so an invoice is not past due until 30 days have past. I made two new fields

days_outstand and days_pastDue.

days_outstand calculation > Today- inv_date

days_PastDue calculation > Today- inv_date + 30

my definitions are missing something but I'm not sure what it is...can someone please help ... Thank you

I closed this thread in the Scriptmaker forum, please do not post into multiple forums, pick the most appropriate one.

Anyway, what is the goal? What are your trying to do with this date?

Create an account or sign in to comment

https://fmforums.com/topic/3146-past-due-date/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.