how do i add a more specific where clause? I want it to be some thing like: WHERE dateadd(day, -30, getdate())

Hello,
Could you please be a little more detailed explaining what exactly do you want to achieve?

Sorry, I would like to show items that have been received in the last 30.

SELECT * FROM itemTable WHERE lastRecievedDate was within the last 30 days from today

Should be something like this: (day, -30, getdate()) . but I can not enter it anywhere like i could in the old DW bindings panel.

Nevermind; I can just use a jquery between datepicker. Can you point to info on that if you have some. I am having trouble with it.

Nevermind again, Just saw your date picker extension.

Hello,
You can use DMXzone Calendar 2 in order to create date-range filter.

My dates are formatted like this: "LST_RECV_DAT":"2014-08-23T00:00:00"
Is there anyway to add the "T00:00:00" to the end of the yy-mm-dd in the Calander 2 extension? I can not get any results unless the date is exact, even when using "contains". If I can get this to work I will Buy this extension immediately.
thanks