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
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
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/
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.
May I know what exactly you have done?
If youa re using DATE2DMY, you have to create an Integer field which stores Month number..
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?
You can..
Are you using Classic Client or RTC?
RTC
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
It says one of the filters is invalid and will be ignored
Did you select right Field?
and what did you enter to filter?
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
Okay, I got a little further now, only the year is the problem now
I cannot seem to leave the year out of it. I filter on the day on which they were actually born, which isn't an annual event.
Check your date format.
Try with 050113..053113
That returns an empty list because nobody is born in 2013.
The year needn't be filled in one way or another.
You were right about the format though, that's not how we're used to it in the Netherlands, we use DD/MM/YYYY
yes, you are right..you cannot give without year.
You cannot achieve your requirement withohut modification.