[Koha-devel] Using date functions in report SQL

[Wagner, Jane]

Does anyone have some examples of using date functions like currdate()
and month() in report SQL statements?  Is this possible in Koha reports?
I'm not having any luck -- even a very simple

select currdate()

report comes back with a generic error message.

Thanks.

Jane Wagner
Library Systems Analyst
PTFS Inc.
Content Management and Library Solutions
6400 Goldsboro Road, Suite 200
Bethesda, MD  20817
(301) 654-8088 x 151
jwagner at ptfs.com