Comparing two timestamp code help??

[rohitians]

Hello,Everyone

I have this following code i am implementing  incremental load by comparing timestamp where in i am uploading new data which has timestamp greater den existing qvd..

But the code is not working while comparing plzz help??

TEMP:

  LOAD

  MAX(Timestamp) as Timestamp1

  FROM

abc.qvd

(qvd);

Let vLastUpdateDate = timestamp(peek('Timestamp1',0,'TEMP'),'DD-MMM-YYYY hh:mm:ss');

  Drop table TEMP;

  abc:

  LOAD

  Timestamp,

  Type,

     User,

     Upper( mid(User,10)) as UserId,

     Message

FROM

C:\ProgramData\QlikTech\QlikViewServer\Audit_QLIKVIEWSERVER.log

(txt, utf8, embedded labels, delimiter is '\t', msq)

where Timestamp >Timestamp('$(vLastUpdateDate)','DD-MMM-YYYY hh:mm:ss');

Thanks and Regards.

Rohit

[jagan]

Hi,

Check the date formats, may be it is the issue.  Check the variable and TimeStamp fields date format.

Regards,

Jagan.

[rohitians]

Hello Jagan,

The format is the same den to I am not getting desired result..

Thanks and Regards,

Rohit