CURRDATE() isn't a function in MySQL. Have a look here: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
CURDATE() ( with one r ) will work, I tried it. Good luck. On Wed, 2009-02-25 at 10:46 -0500, Wagner, Jane wrote: > 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 > jwag...@ptfs.com > > > _______________________________________________ > Koha-devel mailing list > Koha-devel@lists.koha.org > http://lists.koha.org/mailman/listinfo/koha-devel -- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA for Koha checkout http://koha-dev.washk12.org or git://koha-dev.washk12.org/koha _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
