Andrew wrote:
> Simple one hopefully ? Does anyone know the syntax for using a date in a
> filter expression. I've tried heaps of formats and it always tells me my
> expression is invalid. This doesn't appear to be well documented.
One of my old apps has this code in it, which should help sort it
out. I know it works as-is under at least two different date
formats, so the general approach would be to use the current OS
format for the date string, I believe.
Filter := 'Last_Used >'+DateToStr(date-30);
cheers,
peter
============================================
Peter Hyde, SPIS Ltd, Christchurch, New Zealand
* TurboNote: http://TurboPress.com/tbnote.htm
-- small, FREE and very handy
* Print-to-Web automation http://TurboPress.com
* Web design, automation and hosting specialists
Find all the above and MORE at http://www.spis.co.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
