Michael - Good catch :) I didn't even see the typo :) ---
Nicole C. Engard Open Source Evangelist, LibLime (888) Koha ILS (564-2457) ext. 714 n...@liblime.com AIM/Y!/Skype: nengard http://liblime.com http://blogs.liblime.com/open-sesame/ On Wed, Feb 25, 2009 at 10:55 AM, Michael Hafen <mdha...@tech.washk12.org> wrote: > 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 > _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
