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. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
