flowfield - filter absed on date issue

Washout
Member Posts: 24
Hi,
Im trying to create a flowfield which looks up a differant table value.
The filter I want to use is Today-1.
Is this possible using flowfield?
Im trying to create a flowfield which looks up a differant table value.
The filter I want to use is Today-1.
Is this possible using flowfield?
0
Comments
-
I think what you want to to is filter a flowfield based on a dynamic value, so you need to create a new field (or use one that is there), that is a flowfilter, and then have this flowfilter be included in the calculation of the flowfield.
Look at the Item table, Net Change field, CalcFormula, Table Filter. You can see that based on the dynamic selection of the field 'Date Filter', that the formula looks at different posting dates.
In your case, you can se the field in code, something like:
DateToFilterBy := CALCDATE('-1D',TODAY);
SETFILTER("Date Filter",FORMAT(DateToFilterBy);
I hope this is what you mean!
-awarn0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions