web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Using Period Formula i...

Small and medium business | Business Central, N...

Answered

Using Period Formula in AL to Filter Record

(0) Share

Report

Report

Posted on by jdrco

485

Say I wanted to filter Vendors record by the first accounting period of fiscal year 2022 (01/01/22..01/31/22). That would be p1.

How would I filter this record using AL?

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Suggested answer

MahGah 15,613 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Please see below video specially around 7:24 then below link for more data

https://www.youtube.com/watch?v=ldSSu-VUJ60

robertostefanettinavblog.com/.../

Was this reply helpful? Yes No
Verified answer

YUN ZHU 102,054 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, you can use Date virtual table (2000000007)

https://yzhums.com/14819/

Another good way:

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

https://yzhums.com/14547/

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!

Ask A Community Pro

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 1,687 Super User 2026 Season 1

#2

YUN ZHU 1,041 Super User 2026 Season 1

#3

Grigorios Mavrogeorgis 974 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans