News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Find the next open per...

Microsoft Dynamics AX (Archived)

Find the next open period of the calendar from the given date

(0) Share

Report

Report

Posted on by rohit1900

425

Hi I have a requirement where I will be provided the date I have to find whether it is open or not .

if it open then fine else I have to find the next open period in the calender.

say in the calender 1\1\2019 is not opened then I have to iterate to to the next open period and i need to bring the start date of the next immediate open period.

I have started a job like something.

[View:/cfs-file/__key/communityserver-discussions-components-files/33/legdercalenderjob.txt]

Please guide how to proceed from here.

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Satish Panwar 14,645 on at

Like (0)

Report

RE: Find the next open period of the calendar from the given date

Hi Rohit,

Based on fiscalCalendarPeriod status, if it's not open, get the month column, add + 1 and then try to retrieve the next month and then the status and continue till you get the open period status.

Another option is for the fiscalCalendarPeriod, find the enddate, then add + 1 to it and then that's your next transdate and you can repeat your logic until you get the open period status.

Thanks,

Satish Panwar

Please help verify answer(s) if they guide you in right direction so other community members can also benefit from your question with verified answer.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans