I have been stuck for a couple weeks trying to find a way to make a layout where I can set a to and from date to search and make a report.
I am trying to make a system for a Church that is using Quickbooks. I would like to keep it working the same way as they use now but cannot find a way to make it work.
When you go to reports a window opens with some fields like "Dates", "To", and "From". Each of these field can be modified with a drop-down calendar to choose dates. I have a lookup in the Dates field that inserts the correct dates for things like, Today, First Fiscal Quarter, etc. and that is working BUT, I cannot choose "custom" and modify the To or From fields so that other dates can be searched. I have tried global fields and regular fields but they are not editable on screen.
I cannot find any examples that show this being done. I must be able to modify the To and From dates so the correct records can be listed or printed. Sometimes the entry is a couple days after Sunday and I need data for the previous Sunday so that reports are correct.
Anybody have any ideas on how to do this? Examples?