web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Search for month only ...
Microsoft Dynamics NAV (Archived)

Search for month only to create a list of birthdays in May

(0) ShareShare
ReportReport
Posted on by Vincent Hummel 340

Hello everyone,

 

I'm new to NAV, I use 2009. I have to create a list of people whose birthday is in May. However, if I chose birthday as the criterium, I can only specify MM/DD/YYYY efficiently.

I need to specify just the month.

 

Any help would be greatly appreciated.

Vincent

*This post is locked for comments

I have the same question (0)
  • Mohana Yadav Profile Picture
    Mohana Yadav 61,003 Super User 2025 Season 2 on at

    You need to either create new field with Options Jan,feb...Dec to select month

    or you can use DATE2DMY to get month from DOB

    msdn.microsoft.com/.../dd301319.aspx

  • Vincent Hummel Profile Picture
    Vincent Hummel 340 on at

    Thank you for your response, though I have no idea where I'd have to input something like that.

    All I get is a filter option, when I fill in your DATE2DMY-suggestion, it returns that the field isn't valid.

  • Mohana Yadav Profile Picture
    Mohana Yadav 61,003 Super User 2025 Season 2 on at

    May I know what exactly you have done?

    If youa re using DATE2DMY, you have to create an Integer field which stores Month number..

  • Vincent Hummel Profile Picture
    Vincent Hummel 340 on at

    You see, I'm not in a position to edit the things I'm looking for. The existing entries don't have the field you speak of.

    I have to do an assignment for school where I have to make a report of everyone whose birthday is in May.

    So I go to "Departments - Personnel" where I click on Birthdays of Employees, and then I have to specify the criteria on which I have to search.

    However, I cannot search for just a month, or can I?

  • Mohana Yadav Profile Picture
    Mohana Yadav 61,003 Super User 2025 Season 2 on at

    You can..

    Are you using Classic Client or RTC?

  • Vincent Hummel Profile Picture
    Vincent Hummel 340 on at

    RTC

  • Mohana Yadav Profile Picture
    Mohana Yadav 61,003 Super User 2025 Season 2 on at

    We will have Type to filter (F3) option on top of the page.

    You can change the field to whatever you want and set filter

    Ex: Date of Birth, you can set filter like 010113..310113 fro January month

  • Vincent Hummel Profile Picture
    Vincent Hummel 340 on at

    It says one of the filters is invalid and will be ignored

  • Mohana Yadav Profile Picture
    Mohana Yadav 61,003 Super User 2025 Season 2 on at

    Did you select right Field?

    and what did you enter to filter?

  • Vincent Hummel Profile Picture
    Vincent Hummel 340 on at

    I clicked the "Birthdays of employees" option in the report section. Then it asks for my filter.

    There I only filter on Birthday.

    I entered 010513..310513, as in your example

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans