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 Range Calculation

Fei
in Script Workspace and Script Triggers

Featured Replies

Hi this is my first time posting on to the forum. The question may sound stupid. My case is I have a range of data entered daily and while viewing the report, they want it automated by just clicking the buttons without need to key in date range for this week. I have no problem creating for the week and months. For doing this also I have cracked lots of books and come out with it. I just couldn't get the Year done. Can anyone help me on this ? I have attached the file.

date.zip

You could set up two new fields:

  • Author

I have tried the method you mention. But I can't get the result or maybe can you put the idea you had into my attachment and email me ? Thanks for your help. Really appreciate that.

Hi ken,

here is the solution.

Regards,

Henry

sorry, forgot to put the attatchment.

But just tell you now

actually the insert calculation you can put

DateToText(Start Range G) & "..." & DateToText(End Range G)

This will solve.

Any question you can direct call me.

Regards,

Henry

date.zip

Hello Ken

Henry's solution fits your question well. Just for the records the approach with GTRR (Go To Related Records).

dateWithGTRR.zip

  • Author

Thanks guys for your help. Both of your ideas really help me a lot and I learn new stuff again here. grin.gif

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.