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?
0
Comments
-> http://www.mibuso.com/forum/viewtopic.php?t=6662
Microsoft Dynamics NAV Developer since 1997
MSDynamics.de - German Microsoft Dynamics Community - member of [clip]
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?