Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

date filters

Posted on by 130

I am attempting to set a permanent filter on the sales price from the item card.  I enter 01-01-05..01-01-13 for example.  When I go to check to see if the filter took it states that 2005-01-01..2013-01-01 is not a valid date..

Does anyone know how to correct this so it is not reading the date as an international date.  I checked language it is all correct, English first.

Thank you,

Traci

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: date filters

    Very Simple steps as given below.

    In Region dialog box just click on Additional Settings after that click on Date tab and set date format.

  • Labbe Profile Picture
    Labbe 285 on at
    RE: date filters

    Did you look on the Date tab under Control Panel, Region, Additional Settings?

    Lars Bånge

  • Jerry Arth Profile Picture
    Jerry Arth 130 on at
    RE: date filters

    I viewed the regional settings under Country/Region and I do not see where a date format is being followed.  Where would I find the regional settings?

  • Jerry Arth Profile Picture
    Jerry Arth 130 on at
    RE: date filters

    Sorry for the delay, Jerry's email was under my profile.  He has just returned from VAC - I am going to attempt to change the regional settings in NAV and see if that works.

    Hopefully I can locate the regional settings to process.  Thank you.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: date filters

    Jerry, is it done?

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: date filters

    If you don't want to change the date format of your workstation, please change the filter date accordingly.

    It will definitely work.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: date filters

    The date formats are according to the regional settings on your computer, not the language.

    Try to change the regional settings and restart the NAV client.

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans