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

Date based calculation

Oyseka
in Calculation Engine (Define Fields)

Featured Replies

Hi all, I have to change a database that was developed in 2003 and is on FM 5.5. The basis of the change is that a tax that was applied in 2004 is now being removed so I thought that should be simple, just base the calculation on the dates that the tax was applied to. Wrong It doesn't work, can any one see the error in the calculation.

Case(Invoice Date>01/04/2004 and Invoice Date<01/04/2010; Trace Fees *.14;0) At the moment it just removes the tax from all of the invoices

See:

http://fmforums.com/forum/showpost.php?post/236847/

A better solution would be to find the relevant invoices and enter .14 into a tax rate field - then change the calculation to use that field.

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

Search

Search

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.