Date Error

[HMUTUAL01]

I keep on getting the following error message and can't seem to figure out a solution.

[Chanty4u]

Please post the date statement so that we can see how you defined 

[HMUTUAL01]

I'm new. What do you mean by posting the date statement?

[HMUTUAL01]

this is the query

[hic]

That does not look like an error message from any Qlik statement. I suspect it comes from the connector (ODBC or OLE DB or some other connector)  i.e. from a conversion that is needed for one of the SELECT statements.

[HMUTUAL01]

How could I address it?

[vinieme12]

check the respective database docs for a function to convert String to date

convert() / Cast() / to_date() depending on which database you are using