pass yyyy-MM-dd formatted date to PID

[rajkaran07]

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!!!

[gutlez]

PDI Parameters are, by definition, strings.
Try changing the Value Type to String.

[rajkaran07]

In that case I will not have calendar/date picker.

This can cause inconsistent date format...

[gutlez]

You could use a hidden parameter with a formula along the lines of
=TEXT(dateparam;"yyyy-MM-dd")

Then pass this hidden parameter to PDI