On Fri, 2010-02-19 at 18:45 -0500, Drew Jensen wrote: > > > > 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. > Drew,
For a simple query I would not mind so much and that would be a great way to solve it. Unfortunately this query calls upon another query that calls upon another query and so on. I think about 4 levels deep. I guess I could write the whole thing from scratch, but the GUI designer makes it so easy peasy. Keith --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
