Setfilter for DateTime data type
garychick
Member Posts: 34
Hi ALL,
What I want to do is the same as Starting Date Filter in Form 7002. But the data type of my record is DateTime and the input filter is Date (like the Starting Date Filter textbox in Form 7002).
I used SETFILTER("Created DateTime", DateFilter), but nothing will be returned.
Can anyone give me some opinions?
What I want to do is the same as Starting Date Filter in Form 7002. But the data type of my record is DateTime and the input filter is Date (like the Starting Date Filter textbox in Form 7002).
I used SETFILTER("Created DateTime", DateFilter), but nothing will be returned.
Can anyone give me some opinions?
0
Comments
-
Timo Lässer
Microsoft Dynamics NAV Developer since 1997
MSDynamics.de - German Microsoft Dynamics Community - member of [clip]0 -
Thank you for your reply.
But I only want to filter the "date" part of DateTime. I need to ignore the Time part. How to do so?
By the way, can I create a flow field (as in Date datatype) in the same table of the DataTime field which extracts the date of the DateTime field?0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions