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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How get next working d...
Finance | Project Operations, Human Resources, ...
Answered

How get next working date a computed column in views

(0) ShareShare
ReportReport
Posted on by Prem 10
Hi All;
 
I have created a view with WORKCALENDARDATE table. This WorkCalenderTable  contains a filed WorkTimecontrol which gives the status of that particular day whether it is working day or not.
 
My requirement is: - For a non-working day, I need to get the date of next working day in a new computed column against this date.
 
Below is the sample Data as per my requirement 
 
Trans DateWorktime controlNext Working Day
16-08-2023open16-08-2023
17-08-2023open17-08-2023
18-08-2023open18-08-2023
19-08-2023Closed21-08-2023
20-08-2023Closed21-08-2023
21-08-2023open21-08-2023
22-08-2023Holiday23-08-2023
23-08-2023open23-08-2023
 
Thanks in Advance.
I have the same question (0)
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 237,681 Most Valuable Professional on at
    How get next working date a computed column in d365fo Views
    What exactly do you need from us? Does it mean that you don't know how to create a computed column or you don't know what logic to use there?
     
    I think you just need to find the first record (when sorted by TransDate) with open status and TransDate higher that TransDate of the current record.
  • Prem Profile Picture
    Prem 10 on at
    How get next working date a computed column in d365fo Views
    Hi Martin;
     
    Thanks for your reply.
     
    I need the logic to create NextWorkingDay Computed Column as per the requirement.
     
    Thank you.
  • Martin Dráb Profile Picture
    Martin Dráb 237,681 Most Valuable Professional on at
    How get next working date a computed column in d365fo Views
    Yes, I got it, but I don't know what problem you have with it. Please see the suggestion I gave you in the previous reply.
     
    Or are you looking for someone to hire to develop it for you?

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 683 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 563 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 398 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans