Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Regarding Date Filter ...
Microsoft Dynamics NAV (Archived)

Regarding Date Filter in Nav 2016

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi Experts,

    In nav 2009 one table  have a field name "Date Filter" with datatype : Date, FieldClass is Flow Filter,

on  the  Card Form we could enter in "Date Filter" Filed as Date range such that 010117..070717.

Like that the value is allowing in nav 2009.

But coming to nav 2016 on card page when I enter Date range 010117..070717 in the Date filter it's giving 

the following error

            ''Your entry of  "010117..070717" is not an acceptable value for 'Date Filter'. The Value can't be evaluated into type Date."NAV2016error.png

Why it's not allowing in nav 2016 like nav 2009

What should I do.

Thanks in Advance.

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Regarding Date Filter in Nav 2016

    Thanks for All responses,

    I have taken text field in table,

    I replaced date filter field with text field on card page.

  • Suggested answer
    CDsilva Profile Picture
    CDsilva 4,184 on at
    RE: Regarding Date Filter in Nav 2016

    Hi,

    Please Check your Licence for NAV 2016  or use the same licence as of NAV 2009 then restart the service for NAV 2016 and check.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Regarding Date Filter in Nav 2016

    Thank you Nareshwar,

          My system date format and NAV date format are same,

    I need to enter date range in date filter Field on custom card page.

    In this card page when I click on action one function will be called, in this function  date filter value will be used for filtering.

  • Suggested answer
    Nareshwar Raju Vaneshwar Profile Picture
    Nareshwar Raju Vane... 5,596 on at
    RE: Regarding Date Filter in Nav 2016

    Hi,

    Can I know which card page are you trying to filter with Flowfilters?

    Also, check your system date format and check the NAV date format.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans