hi everyone, I can do my date searches no problem, but here's a funny one:

SELECT DATE_FORMAT(DATE(CONCAT(yearparam,'-',monthparam,'-',dateparam)),'%d/%m/%Y')

this (in dmx with the default parameter values set as 2006, 02, and 01, when I click test, returns:

01/02/2006

as predicted, however when i drag dynamic text over onto my page, it inserts :

{rsdate2.DATE_FORMAT(DATE(CONCAT(2006,'-',02,'-',01}

this is putting in the default values for my parameters, and not dynamically assigning the values