I have a simple PDI which accepts a parameter. Then I grabs this parameter with 'Get Variables' step and format it to yyyy-MM-dd. For now I am just outputting this date with Select Values. PDI is working as expected.

When I calls this transformation from Report Designer it throws an error. I have created a date parameter in PRD with
  • Name - executeDate
  • Label - Execute Date
  • Value Type - Date
  • Data Format - yyyy-MM-dd
  • Timezone - Use Server timezone
  • Display Type - date Picker

If I create just a textbox and type in a date, all works fine...

I am suspecting that date is not formatting in specified format.

I am on pentaho 7.1 (PDI and PRD)

Any help!!!