Re: Date sorting Criterion

>
> I'm just trying to create an inventory ageing report and working with
> dates can be tough!  I'm trying to stick with just what Base can do
> naturally, as I'm creating all of my reports with Calc.  This is
> actually working out quite well btw.
>

Oh - so you don't mind if the query requires SQL view? It doesn't have 
to be the full GUI designer.

With the GUI designer turned off and SQL direct (no parameters) then 
this will work fine:
SELECT "DateAcquired" FROM "myinvoice"."assets3" AS "assets3" WHERE 
DATE_SUB( CURRENT_DATE(), INTERVAL 30 DAY) => "DateAcquired"

Save the query and use it normally in the data view to bring into Calc.