Qdabra Tools

Re: Query Builder today - 30 days

ErnestoM — Thu, 17 Jun 2010 17:17:25 GMT

I've accomplished this by having a (hidden) node in the form's xml that does something like addDays(today,-30). Then I reference that value in QueryBuilder.

Re: Query Builder today - 30 days

Jimmy — Thu, 17 Jun 2010 14:01:22 GMT

You'll need to include a date calculation in your query to produce the minimum starting date, and then concatenate that into your query, like this:

concat('[abbreviated...]<gt><column name"StartDate" /><value>', xdDate:AddDays(xdDate:Today(), -30), "</value></gt>[abbreviated...]")

I have a feeling that query builder will not allow you to do this, but you can produce the bulk of your query in QueryBuilder, inserting a dummy value for the StartDate part, and then manually replace the dummy value with the xdDate:AddDays(xdDate:Today(), -30) formula.

Query Builder today - 30 days

Marzipan — Thu, 17 Jun 2010 13:36:37 GMT

I'd like to create a query that will return all items where the start date is within 30 days.

I found the caml example below online. How would we do this with query builder?