Jump to content

Reporting records between a date range


filemakermonster

This topic is 2247 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I have a file that contains records that have a beginning date field and a ending date field.  My summary report is working, it is breaking as it should and contains subtotals and a grand total.  My problem is I want to report records that are between a user entered beginning date and ending date.  How do I get those dates and use them to run my subsummary report?

Link to comment
Share on other sites

Create two new global fields UserStartDate and UserEndDate and place them on a  layout.  Create a script

If[not isEmpty(YourTable::UserStartDate) and not IsEmpty(YourTable::UserEndDate)]
Set Field[YourTable::EndDate; YourTable::UserEndDate]
Set Field[YourTable::StartDate; YourTable::UserStartDate]
Set Field[YourTable::UserStartDate; ""]
Set Field[YourTable::UserEndDate; ""]
Go To Layout["YourSummaryReportLayout"]
End if

Attach a script trigger OnObjectExit which calls this script to both the UserStartDate and UserEndDate fields on the layout.

Link to comment
Share on other sites

This topic is 2247 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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