QlikStart for SAP FI-GL (General Ledger) : Posting date error

[milindnikumbh]

Dear Experts ,

I have successfully build QVD but not able to load the data to QVF file.

I am getting the the following error.

Error in expression:

Date takes 1-2 parameters

Load

  Date(+(Iterno()-1),'YYYYMMDD') as [Posting Date_BUDAT]

Autogenerate 1

While Date(-109205+(Iterno()-1)) <=Date().

Script is as below :

Load

  Date($(vStartDate )+(Iterno()-1),'YYYYMMDD') as [Posting Date_BUDAT]

  // Date, to be used as key field to transactions

Autogenerate 1

While Date($(vStartDate)+(Iterno()-1)) <=Date($(vEndDate));

Please help me to resolve this error.

Best Regards,

Milind.

[kaushiknsolanki]

Hi,

It is because your variable has not got any value.

vStartDate

Check the variable assignment.

Regards,

Kaushik Solanki

[milindnikumbh]

Hi ,

After doing the hardcoding of start date , its giving same error.

Let vStartDate = num(date('20140401','YYYYMMDD'));

Regards,

Milind.

[kaushiknsolanki]

Try this.

Let vStartDate = num(Makedate(2014,01,01));

Same for the enddate.

Regards,

Kaushik Solanki

[Peter_Cammaert]

In your example, you are using a formatting function for interpretation of a date in an irregular format. That won't work.

Use Date#() instead. That's the one that does date parsing and interpretation.

[milindnikumbh]

Hello ,

Still not working . same error.

Please suggest.

Regards,

Milind.

[milindnikumbh]

Not resolved. Still error.

[Leo_M]

Hi, I am receiving the exact same error. Kindly advise if you have found a solution to this issue. Much appreciated.

[Leo_M]

Hi,

I've found  a solution to the problem.

The problem was that it's was not loading data into BSEG_Document_Segment. You need to change your chart of account code.

Please see the thread below:

SAP FI - General Ledger QlikStart Template

[milindnikumbh]

Resolved.