Reports fail with timestamp filter transforms other than "date"

[Brent Mills]

If you are running a quick report that has a base filter on a timestamp field, like:

Classic Item List -> Copy ID -> Circulations -> Checkout Date/Time
Transform: Year

It will fail to process the report with an error "Invalid Parameters: Missing P1".

Adding in the "year_trunc" transform to http://git.evergreen-ils.org/?p=contrib/pines/report-creator.git;a=blob;f=controllers/schedule.controller.php;h=bd284b6cb4bb5fd1dcf2acd83808fdff28680808;hb=HEAD#l202

So that it reads:
if ($lowerTransform == 'date' | $lowerTransform == 'year_trunc')

instead of:
if ($lowerTransform == 'date')

allows the report to head to the scheduler for processing (although this isn't a fix). There, the report will fail because the date passed over to the SQL is in the format YYYY-MM-DD when it needs to be YYYY.

SQL from the same report run on the two different interfaces:
Failed Quick Report SQL: http://pastebin.com/U5hYN323
Completed Evergreen Reports Module SQL: http://pastebin.com/cWEt20W3