Lifeseeker
Registered User.
- Local time
- Today, 10:57
- Joined
- Mar 18, 2011
- Messages
- 273
Hi,
Users would like to do query based on dates. I have been using a filter by form, which works fine. However, when it comes to sorting based on dates, keying in parameters may get time-consuming as users would have to click on "selection" at the top and pick "between..." and specify dates there.
If there is a way to have a form where users can just simply put in date parameter so that they can see a list of facilities who got opened in the last 6 months. So far, filter by form is very limiting with this respect.
Is this possible at all?
what would the query look like for searching dates in the last 6 months?
thanks
Users would like to do query based on dates. I have been using a filter by form, which works fine. However, when it comes to sorting based on dates, keying in parameters may get time-consuming as users would have to click on "selection" at the top and pick "between..." and specify dates there.
If there is a way to have a form where users can just simply put in date parameter so that they can see a list of facilities who got opened in the last 6 months. So far, filter by form is very limiting with this respect.
Is this possible at all?
what would the query look like for searching dates in the last 6 months?
thanks
