Jump to content
  • 0

Date Range on my search form


jerry
 Share

Question

5 answers to this question

Recommended Posts

  • 0

How do I configure my users to be able to search my database based on a date range. For example, I want them to enter a "from" date and a "to" date.

Hi Jerry,

The first thing you need to make sure of is that you have a field with data type Date/Time. Include this field in a search page and add two criteria for it. The first criteria will be "from". The comparison type for these criteria should be "greater than or equal to". The second criteria will be "to". The comparison type for this criteria should be "less than or equal to". The Boolean operator between the two criteria should be set to AND. This will allow your users to search for record by a date range.

Link to comment
Share on other sites

  • 0

Hi Jerry,

Edit your DataPage, click on next and go all the way to the "configure Search Fields" screen, you can see insert button at the bottom of DataPage Elements, just add criteria to your search field, then set the first criteria to "Greater than or Equal" and the second criteria to "Less than or Equal".

Regards,

Bahar M.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...