nuBuilder Forum

admin wrote:kknm,

If you create a criteria (Launch) Form with 2 Objects.

1. themonth
2. theyear

cs.PNG

you can use these values as Hash Cookies both in your PHP and on a Report.

PHP

Code: Select all

WHERE DATE_FORMAT(tabel.tab_data,'%Y %m')= '#theyear# #themonth#'

Steven

This is not optimal.
I have on the form one field with a calendar ('# adat #') and using DATE_FORMAT (tabel.tab_data,% Y% m) = # adat #
I get the year and month in the title in the report.