Webi 4.x - date format on query filter

[Former Member]

Our db2 field is a MMDDYY format.
Our universe has the field formatted as MMDDYY.

I enter a MMDDYY format in the query filter for the date field.

But the generated sql has the entered date as MMDDYY HH:MM:SS
and the query gets an  "The string representation of a datetime value is out of range."  error

How can I get the generated query to format it as MMDDYY?

[Former Member]

This is usually because the prm file has an incorrect InputDateFormat specified for

the DB2 configuration.

Check the location of prm file used in the universe by doing a test connection.

Edit the prm file in notepad and check the format given in "USER_INPUT_DATE_FORMAT", change it to MMDDYY.

Regards,

Ashu Kapoor