Date field show Error - Invalid Month

Fri, 08 Feb 2013 08:47:38 GMT

I have used two date fields as ,

LET ThisExecTime=TIMESTAMP(Now(),'MM/DD/YYYY HH:MM:SS TT');

IF(not IsNull(QvdCreateTime('$(Qvdpath)Roller.qvd'))) then

LatestTime:

LOAD max(PAT_MODIFIED_DATE) as LastExecT FROM $(Qvdpath)Roller.qvd (qvd);

let LastExecTime =TIMESTAMP(peek('LastExecT',0,'LatestTime'),'MM/DD/YYYY HH:MM:SS TT') ;

DROP Table LatestTime;

ENDIF

I am using the variables in the query as SELECT .... WHERE MODIFIED_DATE>= TO_TIMESTAMP('$(LastExecTime)') AND MODIFIED_DATE <= TO_TIMESTAMP('$(ThisExecTime)');

But I am getting an Errr as

"ORA-01843: not a valid month"

Any help on this ?

I have tried updating it as MM also .

Re: Date field show Error - Invalid Month

Fri, 08 Feb 2013 08:53:00 GMT

Hi!

I'm not completey sure, but your date format seems to miss one digit for the month. Shouldn't it be MM/DD/YYYY ? Otherwise I don't see how you want to distinguish October (10) or November (11) from January (1).

Greetings

Wiley_E

topic Date field show Error - Invalid Month in QlikView

Date field show Error - Invalid Month

Re: Date field show Error - Invalid Month