Discussions
Activity
Best Of...
Sign In
·
Register
Home
›
NAV/Navision Classic Client
Howdy, Stranger!
It looks like you're new here. Sign in or register to get started.
Sign In
Register
Quick Links
Categories
Recent Discussions
Activity
Best Of...
Unanswered
Categories
All Categories
73
General
73
Announcements
66.7K
Microsoft Dynamics NAV
18.4K
NAV Three Tier
38.4K
NAV/Navision Classic Client
3.6K
Navision Attain
2.4K
Navision Financials
115
Navision DOS
854
Navision e-Commerce
1K
NAV Tips & Tricks
772
NAV Dutch speaking only
615
NAV Courses, Exams & Certification
2K
Microsoft Dynamics-Other
1.5K
Dynamics AX
317
Dynamics CRM
110
Dynamics GP
10
Dynamics SL
1.5K
Other
993
SQL General
385
SQL Performance
33
SQL Tips & Tricks
34
Design Patterns (General & Best Practices)
Architectural Patterns
10
Design Patterns
5
Implementation Patterns
53
3rd Party Products, Services & Events
1.7K
General
1.1K
General Chat
1.6K
Website
79
Testing
1.2K
Download section
23
How Tos section
259
Feedback
12
NAV TechDays 2013 Sessions
13
NAV TechDays 2012 Sessions
Date Filter
upasanisandip
Member
Posts:
405
2006-05-09
edited 2006-05-09
in
NAV/Navision Classic Client
Hi,
I have created one table with 1 field of date data type.
I want to set date filter like in table G/L Account(15).
I know about Shift+F7 (in upper toolbar ),
I want to do it through program.
Pl. give any hints, suggessitions.
Thanks,
Sandip.
0
Comments
kine
Member
Posts:
12,562
2006-05-09
If you are talking about setting filter to FlowFilter field, you can do it in a standard way - through SETRANGE or SETFILTER.
Kamil Sacek
MVP
- Dynamics NAV
My
BLOG
NAVERTICA a.s.
0
ara3n
Member
Posts:
9,257
2006-05-09
One additional comment. Once you've set your filters through setrange and setfilter, you have to do calcfields on theh flowfields.
example
glacount.setrange("Date Filter",startdate,enddate);
glacount.setrange("G/L Account",11200);
glacount.calcfields(Balance);
Ahmed Rashed Amini
Independent Consultant/Developer
blog:
https://dynamicsuser.net/nav/b/ara3n
0
Sign In
or
Register
to comment.
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
example
glacount.setrange("Date Filter",startdate,enddate);
glacount.setrange("G/L Account",11200);
glacount.calcfields(Balance);
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n