How can I set datefilter

or for a constant date:
Customer.SETFILTER("Date Filter",'..010101');

Basically (but it depends on the case):

If the date filter doesn't change after the form opens then you can use OnOpen,
If the date filter is not table data (you can filter the flowfilter with a variable) then you can use OnAfterValidate

If the form is,
Card type: OnAfterGetCurrRecord (Item Card etc.)
Tabular type: OnAfterGetRecord (Item List etc.)

There are lots of possibilities

Hi,

Thanks for the response!
… but, I think I wasn’t clear at explaining what I’m trying to do – and perhaps I’m taking the wrong approach to this problem.

Here is objective:
I’m modifying the “Item List” (tabular) form to display two fields:
Field#1 (No.71) Purchase (Qty)
Field#2 (Custom Field) Purchase (Qty) for the past 30 days

They are both Flow Fields. Purchase (Qty) is already in the Item table, so it was easy to add it to the form and no programming was necessary.
However, Purchase (Qty) for the past 30 days– requires me to set a filter on the date; i.e. I only want to see purchase quantity for the past 30 days.

This is my code to set a range on the Date Filter:
ToDate := WORKDATE;
FromDate := CALCDATE('-30D', ToDate);
ItemRecord.SETRANGE("Date Filter", FromDate, ToDate);

Since the Custom Field will only be using this date filter, I’m thinking of putting this code behind its field trigger, instead of a trigger that affects the entire form, such as OnOpen, etc. Moreover, it doesn’t work when I run the code behind the following triggers… OnAfterValidate, OnAfterGetRecord.

Any suggestions? Also, is there a better way to solve this problem? I’m sure this is an easy fix for someone out there – unfortunately, with limited experience in Navision programming, I don’t know how else to solve it expect via Flow Field. :-k Many thanks in advance!

Hey David,

Thanks again for your solutions… but, I’m running into some problems.
I decided to go with your solution #1, i.e. specifying another Date Filter.

First of all, to clarify…
1. A Flow Filter allows the user to dynamically change the Table Filter part of the Flow Field, right?
2. If there are multiple Flow Fields within a single table using the same Flow Filter, e.g. “Date Filter”, then setting a range on this filter will impact all Flow Fields, correct?

1. Assuming the above is true, I created a new field called, “Date Filter 2”, (Class: Flow Filter, Data Type: Date) in the Item Table.
2. I modified the custom field’s (MyPurchases) calcfunction property to look like this:
Sum("Item Ledger Entry"."Invoiced Quantity" WHERE (Item No.=FIELD(No.), Entry Type=CONST(Purchase),Posting Date=FIELD(Date Filter 2)))
3. Finally, added the following piece of code to Form-OnAfterGetRecord trigger.

ToDate := WORKDATE;
FromDate := CALCDATE('-30D', ToDate);
ItemRecord.SETRANGE("Date Filter 2", FromDate, ToDate);
ItemRecord.CALCFIELDS(MyPurchases);

Unfortunately, it doesn’t seem to like what I’m doing. Date Filter 2 doesn’t seem to be affected by the SetRange function…
I’m sure I’m missing something really obvious here :? – please let me know… thanks a ton!

Thank you so much - It works now..

Btw, ItemRecord was a record type global variable referencing the Item Table, but like you say... I don't need to explicitly reference the Item table...thanks again!!