Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Date Range Search

Date Range Search

Thread began 6/08/2010 5:35 pm by andy.schofield283961 | Last modified 7/01/2010 5:13 pm by andy.schofield283961 | 1564 views | 4 replies |

6/08/2010 5:35 pm | #1 andy.schofield283961

Date Range Search

The DataAssist search wizard allows me to search for a specific date, if i want to change it to a date range from the search page, is there a simple way to do this....

Apologies if this appears a simple question but would appreciate if anyone can help me....

6/09/2010 12:56 am | #2 Ian

Hi Andy,

Yes, you use two parameters rather than one.

So one lookings for a date >= 'the 1st date field'

AND

The second looks for a date <= 'the 2nd date field'

Hope this helps?

Cheers
Ian

6/09/2010 12:50 pm | #3 andy.schofield283961

Thanks

Ian.

Thanks for the reply, so in DA i set the field to text and use the AND combination.

Please correct me if I misunderstood.

A

6/14/2010 4:29 am | #4 Ian

Hi Andy,

I use the Date data type, greater than or equal to / less then or equal to and the AND statement.

Cheers
Ian

7/01/2010 5:13 pm | #5 andy.schofield283961

Thanks

Thanks Ian, just finished the site now with your help.

Big thank you.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.