Drew said: > > This actually seems to work in the design view Criterion box: > > > > < NOW( ) - 00000100000000 > > > > Returns all dates older than 30 days from now. > > > > Ok, then in MySQL you can use the DATE_SUB function for this. > > Using Base you will need to do this in SQL direct mode (escape > processing turned off) > > and your original question is 'in design view'...ah yes a little reading > would save us both time. > > bugger... > > well it would be something like > > COl (in the field row ) > CURRENT_DATE - 30 (in the criteria row for exactly 30 days ago) > > That works if you do not move off the criteria row in the query > designer, but as soon as you do it quotes all of it... > If you try it as a calculated column with an alias, so you can use the > alias in a where clause...it takes CURRENT_DATE > It quotes again CURRENT_DATE - 30 > > > I'm using XP, a DEV build of OO.o 3.3 and the MySQL native connector > 1.0.1_alpha and your criteria expression doesn't work..same behavior as > the current_date > < NOW( ) - 00000100000000 > > Again this all in the designer if I turn designer off, and still leave > escape processing on (so parameters work) I can then get the SQL to work > as expected. > > I'll fiddle with OO.o 3.2 and the 1.0 stable connector a bit later. > > Still, Looks like you might want to open an issue on this or I will if > you like. >
Drew you have a way more thorough knowledge of these thing than I do. If you could initiate the issue I would appreciate that. And maybe copy me a reference to it. 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. Keith --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
