Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

date filters

(0) ShareShare
ReportReport
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
    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
    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
    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
    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
    on at
    RE: date filters

    Jerry, is it done?

  • Verified answer
    Community Member Profile Picture
    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
    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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Microsoft Dynamics NAV (Archived)

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2

#1
mmv Profile Picture

mmv 2

#1
Amol Salvi Profile Picture

Amol Salvi 2

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans