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.

Range calculation

Featured Replies

Hello Again guys, need help with this calculation/custom function please.

The output I am trying to achieve in a calculation is listed below

15-40500-72000-31500-project title

16-25200-72000-46800-project title

17-25200-72000-46800-project title

18-25200-72000-46800-project title

19-25200-72000-46800-project title

20-25200-42300-17100-project title

I have created a database with a start date and time, end date and time.

The start date and time field produces line number 1 which is

15-40500-72000-31500-project title

and the end date and time produces the last line which is:

20-25200-42300-17100-project title

I need a calculation to produce the filler dates in the range, typically the values

16-25200-72000-46800-project title

17-25200-72000-46800-project title

18-25200-72000-46800-project title

19-25200-72000-46800-project title

it is only the first bit of data that needs to change depending on how many days the user chooses. The 25200-72000-46800-project title will remain the same throughout till the last line. In my example the user chose from 15 of the month through to the 20th of the month. Is this possible?

Create an account or sign in to comment

Important Information

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

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.