Is it possible to query a set amount of days from a date in the column. For example, we want to only show the projects due in the next 7 days from todays date.

Thanks.

Do you know what it would be an option to set a default filtered date? The conditional formatting is nice but not quite the same. Also, can you format the dates differently? Right now they are reading DDMMYYY. Thanks.

Thank you, that fixed what I was looking for in regards to the format. Do you have any word on when the date range would be available or at least a work around in the mean time? I need to show only a certain number of days. So example:

A filtered view would show anything 14 days out plus anything pastdue. Thanks.

Ok no problem, so we have a master table that has all of our projects but we need other tables to display only certain information from the main like a filtered table. The filtered table would only show projects that are due in the next 14 days or past due and not bring back other ones. Currently I have a sql query to the main doc setup which is filtering out the status and columns we don't want but can't figure out how to filter the dates that we'd only like to see. 

Hope that helps. Thanks for the help. 

Bogdan,

I figured out a solution, in my SQL query I can do the following:

Select * from ExampleDatabase
WHERE date_column <= DATE_ADD(NOW(), interval 14 day)

This will bring back information from the database only when the date column is less than 14 days out. This can also be changed to interval 2 month. If you'd like to do do 2 months out.

Also if you'd like to do between two dates, for example between 14 days out and 14 days past due you can do:

WHERE date_column <= DATE_ADD(NOW(), interval 14 day) and date_column >= DATE_ADD(NOW(), interval -14 day)

Hopefully you can introduce a feature into your plugin with these options. :)

Chase