Filter List View by Month?

(0) Share

Report

Posted on by Greg Kujawa

385

So I added a couple of extended date fields off of the Contact record. One for birthday and another for anniversary. When looking at the Contact List I would like to filter them against these field values. But only for the month. Using the date filters in the BC 365 SaaS web UI I don't want to use a range. Since that would evaluate the entire recordset in between. For example, if I wanted all Contacts with December birthdays, defining a date filter of 12/1/1753..12/31/9999 would list all Contacts with any defined birthdays.

Now looking to create something in AL code to accomplish this. I can picture how I would employ the logic. Using something like:

BirthMonth := Date2DMY(Birthday,2);

if BirthMonth = 12...blah blah blah

Can anyone suggest the best way that I could accomplish this? Searching around I can't seem to find an example targeted toward this exact logic.

Categories:

Dynamics 365 Business Central

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 85,883 Super User 2025 Season 1 on at

Like (0)

Report

Filter List View by Month?

Hi, just add some info.

Using the Date Method to retrieve only the Day, Month, and Year Data in Queries [Group by Year-month]

https://yzhums.com/14547/

Thanks.

ZHU
Suggested answer

Greg Kujawa 385 on at

Like (0)

Report

Filter List View by Month?

Disregard, as I delved into the AL query and am using that as a basis for what I need. Like this.

column(BirthMonth; Birthday)

{

Caption = 'Birth Month';

Method = Month;

}