Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
It is because your variable has not got any value.
vStartDate
Check the variable assignment.
Regards,
Kaushik Solanki
Hi ,
After doing the hardcoding of start date , its giving same error.
Let vStartDate = num(date('20140401','YYYYMMDD'));
Regards,
Milind.
Try this.
Let vStartDate = num(Makedate(2014,01,01));
Same for the enddate.
Regards,
Kaushik Solanki
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.
Hello ,
Still not working . same error.
Please suggest.
Regards,
Milind.
Not resolved. Still error.
Hi, I am receiving the exact same error. Kindly advise if you have found a solution to this issue. Much appreciated.
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:
Resolved.