Search within CMSBuilder by Date Range

Hi jtedescojam,

Yes, this is possible. Go into the Section Editor for your section and click on the Searching tab at the top. Add these two lines, replacing your date field name with the example in red:

Date min|mydatefield|min
Date max|mydatefield|max

The only catch here is that you must supply a complete date (including a time.) For example, if you wanted to find all the donations from the start of 2010 to now, leave the max field blank and enter "2010-01-01 00:00:00" in the min field.

Does this help? Please let me know if you have any questions.

okay, not the greatest solution, but it's going to do the job. Problem is I have to teach the client the easiest way to remember how to write the query.. i.e. 2010-08-05 00:00:00

Would be great if we could get this in drop down format.

thanks for being prompt

Hi jtedescojam,

We could build a nice date-input widget into CMS Builder for you through our consulting service. Please let me know if you're interested and I'll write you up a quote.

I'll wait until the database gets intense before we do any custom coding. Maybe I'll try to get this worked into the quote Dave is working on for me.

thanks