topic Re: Invalid Month error in QVC in QlikView

Invalid Month error in QVC

kkkumar82 — Mon, 13 Jun 2016 16:38:51 GMT

Hi all,

I am getting an Invalid month error while trying incremental load using qvc component.

Any help , I am using MM/DD/YYYY format

rwunderlich

Re: Invalid Month error in QVC

miguelbraga — Mon, 13 Jun 2016 16:44:32 GMT

Hello there,

This is the first time that appears this error? If so, does the LAST_UPDATE_DATE have the date in your format? If not, then be careful because you might encounter some problems...

Hope it helps

Regards,

Re: Invalid Month error in QVC

Clever_Anjos — Mon, 13 Jun 2016 16:49:19 GMT

Maybe your Oracle clients is configured into another DATE format

Please use just after your connecti

SQL

alter session set nls_date_format="MM/DD/YYYY"

Re: Invalid Month error in QVC

swuehl — Mon, 13 Jun 2016 16:50:37 GMT

could you try to execute this and post the resulting table line?

SELECT * FROM nls_session_parameters WHERE parameter = 'NLS_DATE_FORMAT';

Re: Invalid Month error in QVC

rwunderlich — Tue, 14 Jun 2016 03:18:17 GMT

If you set the correct database:

SET Qvc.Loader.v.Database=ORACLE;

and then use the QVC generated variable:

SELECT * FROM table

WHERE $(Qvc.Loader.v.IncrementalExpression);

QVC should take care of the correct formatting for datetime.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Invalid Month error in QVC

Anonymous — Tue, 14 Jun 2016 06:43:43 GMT

Hi kkkumar82,

How are you calculating this date?. Use addmonths, don't add +1 in months.

Regards!