Jump to content

Help needed with Birthday date search but client needs to be able to enter date range


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

Recommended Posts

  • Newbies

I Have a database that has members and events for these members.

The client need to enter a from date and to date and when they click on search button it needs to show a report of all events for that period.

[ FROM DATE ] [ TO DATE ] [ SEARCH BUTTON ]

Jemermy - Birthday 15/01

Greg - Birthday 19/01

Where do we find the edit text box to put in there... it needs to be a blank field where you see the [ FROM DATE ] section it keeps asking me to enter in a field name or related data. I just want a blank space.

Please help on how to achieve this and also a simple script.

Thanks in advance.

Edited by Lee Smith
External URLs removed. They made no sense as a reference to this post.
Link to comment
Share on other sites

Where do we find the edit text box to put in there...

 

Not sure what exactly your question is. If you want to get user (keyboard) input, you must give them a field to type into. In the circumstances, you probably want two Date fields, with the storage set to global. These can be in any table. Then you can use a script along the lines of:

Enter Find Mode []
Set Field [Events::EventDate; SomeTable::gFromDate & ".." & SomeTable::gToDate]
Perform Find []

to find events in the given range.

 

 

Note that this will find only events whose date is in the given range - including the year. It will NOT find all people whose birthday is in the given range, if all you have is their DateOfBirth. That's a different problem altogether.

 

 

---

P.S. Why does your question contain links to another forum's actions?

Link to comment
Share on other sites

This topic is 2872 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
 Share

×
×
  • Create New...

Important Information

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