Hi,
I am trying to do a report in which i want to see the document from a period, and the valid credit limit in that period. The credit limit is valid in a defined interval which can be date to date, blank to date or date to blank.
So I started adding the document information in table builder and then compare the posting date with the beginning of the credit limit interval but I receive the same error in different approaches.
Formula used is:
=NL("First","Customer Credit Limit","Credit Limit Amount","End Date",NP("DateFilter",$H21,"30-Sep-2999"),"Start Date",NP("DateFilter","01/01/1900",$H21))
Where H21 is the Document date, and the value in the cell is Document date.
Error message received is: invalid filter "ocument Date..30-09-2999" - not a typo.
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi.
If you are using the table builder then the easiest way to accomplish this is to simply tell the table builder to set a filter on your field and it will auto build the filters into the function. To do this, add the field in the table builder, select it and then add a filter to the report and put in your values. I just did this myself and the field looks like this
=NL("FlowField","Customer","Credit Amount ($)","Filters=",{"Date Filter","..1/1/2016"})
I hope this helps.
Jason -
Jet Reports Historic Posts Hi,
In looking at your error message, it appears that the value in H21 is "Document Date" so you are trying to create a date range that is "Document Date..30-09-2999"
The words "Document Date" are not a date hence your error. If you put an actual date into H21, do you get an error message?
Another thing I noticed is that you want to try to be consistent with your date formats. In my experience, the best way to denote dates is using the / instead of - or . to separate your day, month and year.
Give that a try and let us know.
Please sign in to leave a comment.