invalid month

[smilingjohn]

Hi All

iam trying to implement the incremental load .

below is the script for that and the database is oracle.

after executing this is giving the error as shown in the screenshot .

Incremental:

LOAD

"Dept",

    "RESOLVE_DATE",

    "CLOSE_DATE",

      LOAD_DATE,

    "JIRA_PROJECT_KEY_ID";

From [..\dept.qvd(qvd)];

Last_Updated_Date:

LOAD

Date(max(LOAD_DATE,'MM-dd-YYYY')) as maxdate

Resident Incremental

LET vLast_Updated_Date = Peek('maxdate',0,'Last_Updated_Date');

concatenate

LOAD

"Dept",

    "RESOLVE_DATE",

    "CLOSE_DATE",

     Date("LOAD_DATE") as LOAD_DATE,

    "JIRA_PROJECT_KEY_ID";

SQL SELECT *

FROM "IPMO_SO".JIRA

where "LOAD_DATE" > '$(vLast_Updated_Date)';

Please need help on this

thanks in advance

[sunny_talwar]

Have you fixed the parenthesis?

[smilingjohn]

Hi Sunny

Thanks Legend this works