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

Get Last Payment Date

dcbug
in Calculation Engine (Define Fields)

Featured Replies

Hi,

I'm trying to the last payment date from a line item file.

I can get the Last(PaymentAmount) but not the date of the last payment.

GetAsNumber ( Last (PaymentAmount ) )

works...

I would sort the relationship Date Descending, and take the payment and date from the first record listed.

Stephen--your approach could concievably return values from different records, if for some reason the last record in the result set (from which OP took payment info) did not have the Max(Date).

David

Create an account or sign in to comment

https://fmforums.com/topic/61414-get-last-payment-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.