Invalid Month error in QVC

[kkkumar82]

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

        

[miguelbraga]

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,

MB

[Clever_Anjos]

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"

[swuehl]

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

SELECT * FROM nls_session_parameters WHERE parameter = 'NLS_DATE_FORMAT'; 

[rwunderlich]

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

[Anonymous]

Hi kkkumar82,

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

Regards!