Filtering records in CMS by date range

5 posts by 2 authors in: Forums > CMS Builder
Last Post: March 10, 2013   (RSS)

By pault - March 7, 2013

Please can you let me know if it's possible to add a date range selection under the 'advanced search' area of a list of records within CMS Builder.

For example I may want to only show records with createdDate of yesterday or today so would need a from and to date range.

Thanks, Paul.

By pault - March 7, 2013

Hi Greg,

Thanks so much for your reply, this is great news.  I've just tried it out and it works as you've described but by putting two fields, one for created before and one for created after, the date picker only appears on the second one.

Perhaps when you've got a minute you could take a look and let me know if this is a software problem or my problem!

Thanks again, Paul.

By gregThomas - March 8, 2013

Hi Paul,

I've done some local testing and the advanced search did display two date picker boxes for me. Which version of CMS Builder are you using? Could you post up your advanced search strings for me? 

Thanks!

Greg

Greg Thomas







PHP Programmer - interactivetools.com

By pault - March 10, 2013

Hi Greg,

I was using v2.16 but have upgraded to v2.51 and it now works on both fields.  Thanks for trying it out.

Regards, Paul.